vlookup
 

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,

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!

--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------


"tjh" wrote in message
...
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,

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" wrote:

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!

--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------


"tjh" wrote in message
...
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,

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



"tjh" wrote in message
...
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" wrote:

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!

--
Regards,

RD


--------------------------------------------------------------------------
-
Please keep all correspondence within the NewsGroup, so all may benefit
!

--------------------------------------------------------------------------
-


"tjh" wrote in message
...
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,