Forum Discussion
Ashwin540
Microsoft
Dec 22, 2022Excel value match
Hi
I'm trying to achieve an lookup match where 2 sheets included
Scenario: Sheet 1 having the names and ID column(need to fill )sheet 2 got name and ID
The sheet 1 have A and B where with ref...
Vinit0412
Dec 22, 2022Copper Contributor
Hi Ashwin,
As Harun24HR has mentioned in his reply, XLookup is the best solution to your requirement.
Another way to work on your problem is you can use VLookup function along with IFError function in your "ID" column of Sheet1 as below
=IFERROR(VLOOKUP(A2,Sheet2!A:B,2,FALSE),"ID Not Found")
For your reference, please find the attached workbook with the above formula.