Hi Billy

You're very welcome. I've done it myself countless times before the "penny
has finally dropped".


Regards

Roger Govier


billy_bags wrote:
I knew it would be simple
Thanks very much

"Roger Govier" wrote:


Hi Billy

Have you extended the range definition for scanner_table to include the
additional 2 columns?

Regards

Roger Govier


billy_bags wrote:

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.