I have a table to which I have added 2 further columns
I have a formula which looks up colums 2 and 3 when I key data in column 1
=if(trim(a23)="","",vlookup(a23,scanner_table,2,0) )

The new data I want to select is in column 5 so
=if(trim(a24)="","",vlookup(a24,scanner_table,5,0) )
to which I get the raspberry #REF

I am sure this must be very basic but sometimes I can't see the wood for trees
Any comments would be much appreciated.