Adding to VLOOKUP table

[Guest]

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.

 

[Roger Govier]

Hi Billy

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

Regards

Roger Govier

 

[Guest]

I knew it would be simple
Thanks very much

Hi Billy

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

Regards

Roger Govier

 

[Roger Govier]

Hi Billy

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


Regards

Roger Govier