Link formula like Vlookup

[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.

[Jon_Eynon]

This is awesome and what I am looking for! I have a question... I want to use the second half of the video when you create a linked record referencing the ID. It works perfect if there is a singular match in the lookup table, but what if I have two records that i need to link?

Example: lookup table 'People' contains their company affiliation, email, and if they are the point of contact for that company. I have an Invoices table where I will use your script to match them to their company affiliation and return People ID to the linked column in Invoices. The issue is that I may have more than one person that is the point of contact. How can I adjust the loop and ADD to that linked column in Invoices and not just replace the first one?

Thanks in advance. This script is the bomb!