Vlookup for Airtable?



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)

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!



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


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


You might want to take a look at this post.