Forum Discussion
sjoerdbuis
Jan 17, 2025Copper Contributor
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)))
- sjoerdbuisCopper Contributor
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?
- sjoerdbuisCopper Contributor
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
- sjoerdbuisCopper Contributor
4 lines in the dataset with 3 times type C and D linked to Anton
Why do you have Anton 3 times in the desired result?