Lookup using another Lookup as reference

Options
jerrardli
jerrardli Member, ALL USERS, Community Member Posts: 1 New Contributor

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.