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.