Is it possible to use a formula to compare columns of a table?

Topic Labels: Formulas
1144 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

I’m trying to use function IF , but it seems not to work with entire columns, only with specific values or texts. I need to compare like I do in sheets, e.i : IF(A2 = D2, “Valid”, “Not Valid”). I don’t know how to use formulas with cells or if it’s even possible.
I have another question regardings lookup, is there some way to use like a vlookup with fields that arent the key ones?

1 Reply 1

That formula would be the same in Airtable.

Just put brackets around the field names, and make sure that you use straight quotes instead of curly quotes.

So your formula would look like this:

IF({Field 1} = {Field 2}, "Valid", "Not Valid")

VLOOKUPS don’t exist in Airtable, but we do have “lookup field” where you can pull in data from another table based on a “linked record” field.

To learn more about lookup fields in depth, you can read through Airtable’s support documentation, or you can check out my Airtable training course, which you can take for free by signing up for a trial membership with LinkedIn Learning: