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.
Solved! Go to Solution.
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