Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

How to implement ArrayFormula(Vlookup)) in Airtable

Topic Labels: Formulas
136 0
cancel
Showing results for 
Search instead for 
Did you mean: 

I have 2 Tables.
Table A contains a field for a start date and a field for an end date and a unique ID field.
Table B contains a date field.

What I want is on Table B, when I input a date, I want it to return the unique ID field on which the date in Table B falls in, relative to the Start Date and End Date in Table A.

This is Table A
image

This is Table B
image

My input field in Table B is Col B, and the output is Col C.

The formula I found on Google Sheets to make this work is
=ARRAYFORMULA(IFERROR(VLOOKUP(A2:A,‘INPUT - Live Streams’!A2:C,3,1)))

Is there a way I can implement the same setup in Airtable?

0 Replies 0