Vlookup

%3CLINGO-SUB%20id%3D%22lingo-sub-3406945%22%20slang%3D%22en-US%22%3EVlookup%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3406945%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%202%20spreadsheets%2C%20in%20the%20Invoice%20Details%20spreadsheet%20I%20would%20like%20to%20match%20the%20unique%20no%20(column%20A)%26nbsp%3B%20with%20unique%20number%20found%20in%20the%20CMR%20spreadsheet%2C%20then%20if%20they%20match%20it%20should%20give%20me%20the%20data%20in%20the%20found%20in%20the%20CMR%20spreadsheet%20in%20column%20G.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3406945%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

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

@Debbie001622 

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.