range expression problem

  • Thread starter Thread starter firewolf2000
  • Start date Start date
F

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
 
See if INDIRECT(B1) does the trick.

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

HTH
Regards,
Howard
 
Back
Top