Help

Re: VLOOKUP in Airtable

539 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Tiaan_Terblanch
6 - Interface Innovator
6 - Interface Innovator

In my base, I have 2-tables. The first table contains all of my primary data—the second table with additional data related to my first table.

In table-1, I have a column named “month number”, which means a number will represent a month; i.e. 2 = February or 12 = December etc.

It looks like this:

Month Number
1
5
8
9

In table 2, I have a column named “Month”, with all the months of the year in their own lines.

Example:
JAN
FEB
MAR

Next to that column, I have a column named “Month Number.” Which obviously resulted in having numbers 1 to 12, next to the months of the year.

In my first table, next to the column named “Month Number” I’ve added a column called “Month_Name”. In this column, I want the column to identify that a number represents a specific month name and fill in the column with the corresponding name.

For example:
If 4 = APR, then I want APR to appear in the “Month_Name” column next to it’s “Month Number” column.

So it will look like this:

Month Number
4

Month_Name
April

Your help will be highly appreciated.

Thanks

1 Reply 1

This can be done without a second table. Turn the {Month_Name} field into a formula field using the following formula:

DATETIME_FORMAT(DATETIME_PARSE({Month Number} & "", "M"), "MMMM")

Screen Shot 2020-06-25 at 3.07.19 PM