May 20 2022 09:44 AM
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.
May 20 2022 10:05 AM - edited May 20 2022 10:05 AM
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.