VLOOKUP

[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.

 

[T. Valko]

=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.

 

[Rob H]

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.

=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.

--
Biff
Microsoft Excel MVP

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.

 

[T. Valko]

Good deal. Thanks for the feedback!

--
Biff
Microsoft Excel MVP

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.

=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.

--
Biff
Microsoft Excel MVP

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.