Forum Discussion

alangibson12's avatar
alangibson12
Copper Contributor
Sep 05, 2020
Solved

Lookup 2 Tables based on IF AND statement

Hi I am trying to 1. Lookup a table and reference a value based on being equal to or less than. 2. Return a value in the next column 3. Have a condition that looks up a separate table.   A nest...
excel
Formulas and Functions
  • alangibson12's avatar
    alangibson12
    Sep 05, 2020

    Riny_van_Eekelen 

    That is so good, thank you.

    Its my first post and i was hoping it would be worth asking.

     

    Thanks for tidy up as well, I would have done the same.

    I almost split the tables before upload, but thought i will split when i get the formula sorted.

    So made me laugh when you did.

    Also the drop down on 1 and 2 and naming Tables to 1 and 2

     

     

     

     

     

     

     

     

     

     

PeterBartholomew1's avatar
PeterBartholomew1
Silver Contributor
Sep 05, 2020

Riny_van_Eekelen 

Just for fun, this solution is dressed up like a Christmas Turkey!

I have given alternatives implementations with and without the Microsoft 365 LET function.

= LET(
  selectedTable, CHOOSE(tblIndex, Table1, Table2),
  LOOKUP(discount, selectedTable) )

Resources