Forum Discussion
Lookup from values in two columns
Should be relatively easy but i need a calculation for the result in the right All help is welcome
Formula in F2 is
=INDEX($A:$A, SUM(($B$2:$C$4=E2)*ROW($B$2:$C$4)))
Hans, this looks like as great sdolution, however i cannot replicate this.
I have attached a case. Could you fill in the calculation in the yellow cells?
Here is the workbook with a formula that works with structured table references.
