Lookup using another Lookup as reference

Is it possible to use a Lookup as criteria within another Lookup?

 

Using Excel as an example; vlookup(vlookup(A1,B:D,3,0),Sheet3!B:D,0)

 

I know the workaround would be to create a seperate list where the value of the Lookup becomes a reference use for another Lookup in a different list. However just wondering if it is possible to combine the lookup's simliar to Excel.

Best Answer

  • @jerrardli

    Hi

    No, it is not possible to combine the LOOKUPs

    It is best practice to split formulae anyway, but in this case it's not actually possible!

     

    One big advantage in separating the LOOKUP, is that is can be referenced again by other formulae which a lot more efficient

     

    I hope this helps

    David