vlookup

[Guest]

hello,

I am using a vlookup such as:

=vlookup(a8,FST,9,false)

I would like the FST to reference another cell such as:

=vlookup(a8,b1,9,false)

When I do this it gives me a #N/A error. How can I make this work.

Thank You,

 

[RagDyer]

Can you put into plain words *exactly* what you're trying to accomplish with
the formula that you posted, because your syntax for the Vlookup function is
not right!

 

[Guest]

I am using cell a8 to reference a value in another worksheet.

FST is the range name in the other worksheet. This is what I would like to
reference another cell for (The text in another cell would say "FST" but the
vlookup formula would show B1 in that section)

9 is how many columns to the right of the referenced cell that the value I
am looking up is.

False -- it is not sorted in any order

Please let me know if you need more.

Thank You,

 

[RagDyer]

What confused me was when you mentioned that FST was to reference a single
cell, where I thought you meant the range was to be a single cell.

Sorry!

Try this :

=vlookup(a8,indirect(b1),9,false)
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================