| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup - dynamic range reference?
I am trying to do a vlookup that will look in a different range based on an input cell. =vlookup(d1,b1,2,false) where b1 changes to different sheets (i.e. if b1 = adam, then look in named range adam). would also like to do it without using named ranges but seem to be stuck. I tried using indirect(b1) but that didn't work. thanks in advance Adam -- aseanor ------------------------------------------------------------------------ aseanor's Profile: http://www.excelforum.com/member.php...o&userid=29161 View this thread: http://www.excelforum.com/showthread...hreadid=572769 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Crate group of date, with Dynamic Range in pivot table not working | Excel Discussion (Misc queries) | |||
| Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
| dynamic summed range based on a variable | Excel Worksheet Functions | |||
| Using a cell reference of a sheet in Vlookup | Excel Worksheet Functions | |||
| Dynamic named range across multiple sheets | Excel Discussion (Misc queries) | |||
Threaded Mode
