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?
Is it possible to use a formula to compare columns of a table?
+35That 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:
Login to the community
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.