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

[Aleksander_Kiri]

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:

[Kamille_Parks]

Aleksander_Kiriakow:

I can get both as excel files and thus read them into Airtable.

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}
)