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,