Forum Discussion

EK_Blackwell's avatar
EK_Blackwell
Copper Contributor
Sep 07, 2021
Solved

IF THEN WHERE statement?

I have two sheets in a workbook. I need to set a cell's value where the ID on one sheet equals the ID on a different sheet. But there's not always going to be a match, they don't line up equally.  Is...
excel
Formulas and Functions
  • SergeiBaklan's avatar
    SergeiBaklan
    Sep 07, 2021

    DKoontz 

    As a comment, with XLOOKUP we may return entire spill at once

    =XLOOKUP(A2:A10,Sheet2!B2:B100,Sheet2!A2:A100, "no such")
Juliano-Petrukio's avatar
Juliano-Petrukio
Bronze Contributor
Sep 07, 2021

EK_Blackwell 

 

Please consider convert to number the ID values

=INDEX(Sheet2!A2:A17,MATCH(A2,Sheet2!B2:B17,0),1)

 

  • EK_Blackwell's avatar
    EK_Blackwell
    Copper Contributor
    Sep 08, 2021
    Thank you, everyone! The formula is working!
    • Juliano-Petrukio's avatar
      Juliano-Petrukio
      Bronze Contributor
      Sep 08, 2021
      Anytime
      I would like to ask you please to flag the post as answered.

Resources