Forum Discussion

Ashwin540's avatar
Ashwin540
Icon for Microsoft rankMicrosoft
Dec 22, 2022

Excel value match

Hi  I'm trying to achieve an lookup match where 2 sheets included Scenario: Sheet 1 having the names and ID column(need to fill )sheet 2 got name and ID  The sheet 1 have A and B where with ref...
  • Harun24HR's avatar
    Dec 22, 2022

    Ashwin540 Use XLOOKUP().

    =XLOOKUP(A2:A4,Sheet2!A:A,Sheet2!B:B)

Resources