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.


--
gws-mtc
------------------------------------------------------------------------
gws-mtc's Profile: http://www.excelforum.com/member.php...o&userid=33376
View this thread: http://www.excelforum.com/showthread...hreadid=532035

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)),"",VLOO KUP(A1,X$1:Y$999,2,FALSE))

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

--


gws-mtc Wrote:
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
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=532035