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.
Jun 08, 2021 02:37 PM
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:
Jun 08, 2021 03:08 PM
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}
)