suresh narasimman
suresh narasimman

Reputation: 75

looking for exact match with 2 excel sheets and return the data

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.sample picture

ran up with vlookup and I cant help me out

Upvotes: 0

Views: 68

Answers (1)

Pᴇʜ
Pᴇʜ

Reputation: 57743

Where is the issue using VLOOKUP?

=VLOOKUP(A2,SheetB!A:B,2,FALSE)

Upvotes: 2

Related Questions