Debra Dalgleish has lots of notes on =vlookup() and =index(match()) he
http://www.contextures.com/xlFunctions02.html (for =vlookup())
and
http://www.contextures.com/xlFunctions03.html (for =index(match()))

wrote:

I am seeking to match rows of one excel workbook with a another
booklet.

I have tried v lookups but have had no success with these bc the
vlookup only identifies the row and the column intersection and not
whats in that cell.

I want a solution that will read whats in a cell. I.e. Unique id
34343. Then find the unique ID 34343 in another cell of another
workbook and return specific data in the same row of the unique Id.

I extremely desperate for a solution. if you need more explanation i
can provide this, moreover, for anyone who is seeking a challenge this
may be for you.

Thank you.

--

Dave Peterson