Forum Discussion

sjoerdbuis's avatar
sjoerdbuis
Copper Contributor
Jan 17, 2025

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

 

    • sjoerdbuis's avatar
      sjoerdbuis
      Copper 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?

       

       

    • sjoerdbuis's avatar
      sjoerdbuis
      Copper 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

  • sjoerdbuis's avatar
    sjoerdbuis
    Copper Contributor

    4 lines in the dataset with 3 times type C and D linked to Anton

Resources