Vlookup for Airtable?


#1

Greetings,

I have an Airtable field titled: Course Status and to the right of that field is Total Enrollment. In my Excel spreadsheet version, I used a vlookup to return the value of ‘course status’

The formula: =VLOOKUP([@Enrolled],Table30,2,FALSE)

Table30
0-2 enrolled = On Standby
3-9 enrolled = Low Enrollment
10-28 = Will Make!

Is there a way to accomplish this in Airtable?

Thanks in advance for your support!

Lisa


#2

Have you tried using a lookup field? It should work perfectly for what you want to do.


#3

I also have this problem and it’s not at all clear how to use Lookup to accomplish this.


#4

You might want to take a look at this post.