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.
For every_line in ColA (for every_line in ColB check if ColA_item = ColB_item → return ColB_item)
Does this make any sense?