Sorting/Filtering data ???

[gws-mtc]

I am looking at organizing two sets of data. For example, the data in
Column A would be distance (say every 2 ft. - 0 to 10,000). Columns B
& C would have data associated with each 2 ft. increment. Another set
of data - Col. X = Distance, every 50 ft. and Col. Y = Data.

Question:

How do I take the data of Col. Y and have it match up with the
distances of Col. A without cutting and pasting every piece?

Please advise.

 

[Bryan Hessey]

Your heading -'Sorting/Filtering Data' -is confusing and does not relate
your questionwell.

Assuming column D were blank, in D1 put

=IF(ISERROR(VLOOKUP(A1,X:Y,2,FALSE)),"",VLOOKUP(A1,X:Y,2,FALSE))

or


=IF(ISERROR(VLOOKUP(A1,X$1:Y$999,2,FALSE)),"",VLOOKUP(A1,X$1:Y$999,2,FALSE))

and formula-copy this to the end of your column A data.