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!