VLOOKUP

  • Thread starter Thread starter Rob H
  • Start date Start date
R

Rob H

Using Excel 2003. I am trying to lookup a value in a separate workbook
called 2008Studio which has one worksheet called ST. Data is in cells A2 to
A 176. The cells are all formatted as general.

have tried using "Insert, Function which gives me

=VLOOKUP(B6,[2009Studios.xls]ST!A2:A176,2,FALSE)

I have also tried =VLOOKUP(B6,[2009Studios.xls]ST!,2,FALSE)

but all is get is #REF in the target cell.

Any help would be appreciated.
 
=VLOOKUP(B6,[2009Studios.xls]ST!A2:A176,2,FALSE)

The problem is that your lookup_table only has one column yet the
col_index_num argument is set to column 2.
 
Thanks, I changed the col_num_index to A2:M176 and it worked right away - it
certainly wasn't made clear in the help or the MS manual that I needed the
whole array description.

T. Valko said:
=VLOOKUP(B6,[2009Studios.xls]ST!A2:A176,2,FALSE)
Click to expand...

The problem is that your lookup_table only has one column yet the
col_index_num argument is set to column 2.

--
Biff
Microsoft Excel MVP


Rob H said:
Using Excel 2003. I am trying to lookup a value in a separate workbook
called 2008Studio which has one worksheet called ST. Data is in cells A2
to
A 176. The cells are all formatted as general.

have tried using "Insert, Function which gives me

=VLOOKUP(B6,[2009Studios.xls]ST!A2:A176,2,FALSE)

I have also tried =VLOOKUP(B6,[2009Studios.xls]ST!,2,FALSE)

but all is get is #REF in the target cell.

Any help would be appreciated.
Click to expand...
Click to expand...
 
Good deal. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


Rob H said:
Thanks, I changed the col_num_index to A2:M176 and it worked right away -
it
certainly wasn't made clear in the help or the MS manual that I needed the
whole array description.

T. Valko said:
=VLOOKUP(B6,[2009Studios.xls]ST!A2:A176,2,FALSE)
Click to expand...

The problem is that your lookup_table only has one column yet the
col_index_num argument is set to column 2.

--
Biff
Microsoft Excel MVP


Rob H said:
Using Excel 2003. I am trying to lookup a value in a separate workbook
called 2008Studio which has one worksheet called ST. Data is in cells
A2
to
A 176. The cells are all formatted as general.

have tried using "Insert, Function which gives me

=VLOOKUP(B6,[2009Studios.xls]ST!A2:A176,2,FALSE)

I have also tried =VLOOKUP(B6,[2009Studios.xls]ST!,2,FALSE)

but all is get is #REF in the target cell.

Any help would be appreciated.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top