Reputation: 75
In excel sheets there are two sub-sheets A and B contains name and id were named to compare with sheetB if it exact match retrieve the data and filled up with sheet.
ran up with vlookup and I cant help me out
Upvotes: 0
Views: 68
Reputation: 57743
Where is the issue using VLOOKUP?
VLOOKUP
=VLOOKUP(A2,SheetB!A:B,2,FALSE)
Upvotes: 2