Is it possible to do the equivalent of a nested VLOOKUP function within Airtable? I have three tables and want to lookup a value from one and use it to lookup the value in another. For instance, in Numbers, it looks like this: (VLOOKUP(VLOOKUP(B2,'Type/Class':Material,4,close-match),Metals Summary::A:B,2,close-match)×I2)+P2
@AirtableApp
2 жыл бұрын
Hi Timothy! Aron here. I'd recommend first looking up each field you'll field (Type/Class, Material etc.) and then using a formula field to get the output you need! For a more detailed look I'd recommend reaching out to support!
@lisajenrette1778
2 жыл бұрын
I don't have a formula field? Can you point me in the right position on how to do this?
@connorfinlayson
3 жыл бұрын
Look at that level of content repurposing 🤩
@AirtableApp
3 жыл бұрын
Trying to give the people what they want! 😅
@aokcreative
2 жыл бұрын
How do I create a formula which is adding a letter to autonumber?
@AirtableApp
2 жыл бұрын
Hi Antonia, you can use the concatenate formula function! If you need more detailed help, I'd recomment reaching out to support!
Пікірлер: 9