1 vote

Best way to define a 2D lookup in excel using lambdas?

Here is one way without using any LAMBDA() helper functions: • Formula used in cell C8 =_2D_LOOKUP(A1:E4,A7,A8) Where _2D_LOOKUP() is defined name in name manager, and refers to the following ...
Mayukh Bhattacharya's user avatar
1 vote

Excel xlookup formula

If the list of products is in G1 you can use a formula: =ADDRESS(MATCH(G1,$A$1:$A$4,0),MATCH(TRUE,INDEX($B$1:$E$4,MATCH(G1,$A$1:$A$4,0),0)>0,0)+1,4)
MGonet's user avatar
  • 1,907

Only top scored, non community-wiki answers of a minimum length are eligible