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 dat...
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.