Sorting/Filtering data ???

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.

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.

--

Originally Posted by 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.