range expression problem

[firewolf2000]

I am trying to search multiple ranges using a single formula. I am
doing this by having a cell that represents the range that tells the
formula where to look. I am also using vlookup for this layout.
Visually, here is what I am doing.

A B
lookup (formula =Vlookup(A1,(Range from B),2)
Value Returning
RangeName to
Search)

I believe my current problem has to do with specifying the Range. I
have tried the methods Value(A1), Range(Value(A1)), and Range(A1) to no
avail. What would be the proper format for me to specify this type of
structure?

Thanks

 

[L. Howard Kittle]

See if INDIRECT(B1) does the trick.

=Vlookup(A1,Indirect(B1),2,0)

HTH
Regards,
Howard

 

[firewolf2000]

That got it.

Thanks