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.

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.

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.

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.