Forum Discussion

Deleted's avatar
Deleted
Jul 08, 2020

Comparing a value against a table for match

Hi, I'm looking for 2 formulas to compare a value against a table in excel to return 1) a match and 2) another value.

Below is an example of the excel table.

What should be the input formulas in the yellow highlighted field for expected result.

Thanks.

 

 

excel
Formulas and Functions

1 Reply

  • PeterBartholomew1's avatar
    PeterBartholomew1
    Silver Contributor
    Jul 08, 2020
    = XLOOKUP( 1,
  MMULT( SIGN(identityTable=identityNo), {1;0;1;0;1;0} ),
  lastName,
  "False" )

    In older versions of Excel LOOKUP could be used in place of XLOOKUP. 

Resources