Lookup using another Lookup as reference

New Contributor

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.

Message 1 of 2
1 REPLY 1
Community Boss

Re: Lookup using another Lookup as reference

@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

Message 2 of 2