| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to reference the value from another cell in a VLOOKUP table array
Hi all,
Excel user with basic skills he I am trying to produce a sheet which will do various calculations, based on a filtered selection. I have looked at the SUBTOTAL function, but it cannot do all of the calculations I want it to do. Basically, what I would like is for a VLOOKUP table array to be based on the value in another cell. My lookup range is currently S3:S162. I would like the 162 in "S162" to be the value which is located in cell B164 (this is a SUBTOTAL, function 103), +2. I've had a play with the INDIRECT function, but cannot seem to type the correct thing, if indeed the correct thing is at all possible. Any help would be greatly appreciated! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vlookup Using a Reference as a Table Array | Excel Worksheet Functions | |||
| Vlookup - using a cell to reference a named array | Excel Worksheet Functions | |||
| Replacing a Table-array with a cell reference in vlookup | Excel Worksheet Functions | |||
| use cell reference,whose contents= a table array name for Vlookup | Excel Worksheet Functions | |||
| Using single cell reference as table array argument in Vlookup | Excel Worksheet Functions | |||
Linear Mode
