Airtable Cobuilder is here! Learn more about our new no-code app creation feature, powered by AI on the Airtable Academy

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

292 0
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

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:

   {ColA} = {ColB},
   {Col B}