Forum Discussion
Vlookup
I have 2 spreadsheets, in the Invoice Details spreadsheet I would like to match the unique no (column A) with unique number found in the CMR spreadsheet, then if they match it should give me the data in the found in the CMR spreadsheet in column G.
1 Reply
If you have Microsoft 365 or Office 2021:
=XLOOKUP(A2, 'CMR'!$A$2:$A$1000, 'CMR'!$G$2:$G$1000, "")
If you have an older version:
=IFERROR(VLOOKUP(A2, 'CMR'!$A$2:$G$1000, 7, FALSE), "")
Change CMR to the actual name of that sheet.
