Using IF function across separate tables

[UK_Richie]

Hi There,

I work in retail and the till software I use produces two spreadsheets for me. The first contains all the items sold and gives an order ID to show which ones where sold together. The Second tells me what store each order ID happened at.

I have added a column to the first spreadsheet and I want to show what store each item was sold at. However I am unable to get the IF function to work properly.

Hope this makes senses, see example of spreadsheets attached.

Please help.

Many thanks,
Richard

[Roel Jongman]

Don't use an if function for that but a vlookup

=VLOOKUP([@[Order ID]];Table3;2;0)

Table3 contains the transaction example (see attachment)

Also don't drop new columns in the middle of an existing table. Put new columns of data looked up in other tables at after or before the item table columns.
this way you can always copy and paste new item transactions into the new file.
if you put a column in between the columns you have to reorganise the columns each time you have new output file from the till.