Thread
:
Using Sheet names in formulas
View Single Post
#
2
Posted to microsoft.public.excel.programming
Don Guillett[_4_]
external usenet poster
Posts: 2,337
Using Sheet names in formulas
Have a look in HELP index for INDIRECT.
--
Don Guillett
SalesAid Software
"bsullins " wrote in message
...
I need to be able to make my vlookup formula dynamically change the
range based on the result of another lookup....
Here is a simple vlookup:
VLOOKUP($a$1,L1!$a:$Z,2,0)
I need it to do something more like this
VLOOKUP($a$1,"$B1"!$a:$Z,2,0)
Using a cell ref in the table name would allow the value in $B1 tell
the formula what ws to look at
In this scenario A1 could be found on various sheets, and I need to be
able to figure out which one then look at that sheet.
It would be nice if I could do this with a formula trick instead of VBA
since everyone here is scared of macro's.......
---
Message posted from
http://www.ExcelForum.com/
Reply With Quote
Don Guillett[_4_]
View Public Profile
Find all posts by Don Guillett[_4_]