Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Checking for occurrence of fields in ColB in ColA, ie order items in backorder list

Topic Labels: Formulas
181 1
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi!
I am new to Airtable - and it shows a lot of promise but I have a hard time wrapping my head around it.

I need to check my orders against a backorder list.
I can get both as excel files and thus read them into Airtable.
Then I need a crosssection of the columns.
Something like:
For every_line in ColA (for every_line in ColB check if ColA_item = ColB_item → return ColB_item)

Does this make any sense? :slightly_smiling_face:

1 Reply 1

Are you importing two different Excel files/sheets into one Airtable table? Depending on what your data looks like that might not be best practice.

But to answer your question directly, to compare the value of {ColA} to the value of {ColB} for each record, crate a Formula type field with this formula:

IF(
   {ColA} = {ColB},
   {Col B}
)