| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
use a cell to reference a range in a vlookup
I have a spreadsheet that has the same line on it, and would like to automate
a vlookup so that i do not have to change the tab name. I have the tab names in a column already, before that cell I was making the range with a formula so that I coudl reference that cell to define my range. That does not seem to be working, does anyone know how to work around that? Example below Formula that works =VLOOKUP("a",Sheet2!1:65536,2,FALSE) Formula that does not work A1 = Sheet2!1:65536 =VLOOKUP("a",A1,2,FALSE) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Offset Function works in cell, not in named range | Excel Worksheet Functions | |||
| macro help | Excel Discussion (Misc queries) | |||
| How to dynamically reference a dynamic named range | Excel Worksheet Functions | |||
| How do I refer a Range to a Cell | Excel Worksheet Functions | |||
| Adding contents of one cell to a range of cells. | Excel Worksheet Functions | |||
Threaded Mode
