Forum Discussion
Matching Data Points
I have two spreadsheets- I need to transfer data points on one workbook, into another. The data points are in one column, and are ID's in a preceeding column. So let's say 'ID' is column A and the 'd...
LRombro You can use the VLOOKUP or XLOOKUP function for this. For example:
=VLOOKUP(A2, '[OtherWorkbook.xlsx]SheetName'!$A$2:$B$1000, 2, FALSE)
or
=XLOOKUP(A2, '[OtherWorkbook.xlsx]SheetName'!$A$2:$A$1000, '[OtherWorkbook.xlsx]SheetName'!$B$2:$B$1000)