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 ...
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)
Only top scored, non community-wiki answers of a minimum length are eligible
Related Tags
worksheet-function × 8101microsoft-excel × 7223
microsoft-excel-2010 × 1631
microsoft-excel-2007 × 791
vba × 572
microsoft-excel-2016 × 441
microsoft-excel-2013 × 426
spreadsheet × 216
vlookup × 211
conditional-formatting × 180
google-spreadsheets × 160
macros × 141
libreoffice-calc × 115
date-time × 113
countif × 109
array × 98
pivot-table × 80
microsoft-excel-365 × 67
microsoft-office × 63
cells × 61
date × 60
libreoffice × 59
openoffice-calc × 57
lookup × 57
charts × 56