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.

Tags

Modeling

Calculation Functions

Accepted answers

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

All comments

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

Quick Links

Can you help?

Unanswered questions

Hide the cards under "Models" section once connected
Hi Is there a way to hide the cards under the "Models" section once connected, as I would like the users to see only the links to the apps? Thank you
OData Rest API for
Hi, Does anyone know how to get an outbound OData Rest API, (OAuth2) to establish a connection between SAP and Anaplan. Thanks Khaled
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…