Vlookup for Airtable?

[Lisa_Altizer]

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

[EM_McQuillan]

hi, is there anywhere I could find an easier version of the script to amend, please?

[Britt_Givens]

Hey Bill -

Wondering if you could help me solve my problem, I am doing something very similar to this , however I have multiple return values for a given search value.

EX) Zip code 10001 exist in a few different cells in my search range, and when I run my function it only diplays one value apposed to all possible solutions.

Any ideas on how to fix?

[Bill_French]

Britt_Givens:

I am doing something very similar to this

Sorry Britt, I need a lot more information to be able to help. What is “this”. The thread has many things mentioned.