Lookup using another Lookup as reference

[jerrardli]

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.

[DavidSmith · Accepted solution]

@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