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.