Forum Discussion

LRombro's avatar
LRombro
Copper Contributor
Nov 11, 2022

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 'data point 'is column B. Is there a way to write a formula in my other spreadsheet which contains the 'ID' that basically says if this and this match then this column should equal that 'data point' in column B, and of course be able to make it dynamic and put that through and entire column ?

excel
Formulas and Functions
  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Nov 11, 2022

    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)

Resources