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)))
your solution looks great but i can't seem to replicate it. I have added a file, could you fill this calc in the yellow lines of tab dataset? result should be derived from column B and the search table