| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Basing a range for a linked spreadsheet on internal criteria
Hello,
I am trying to modify the following formula: =VLOOKUP(10,'W:\CARS Accounting\CARS Recs\Prod, Susp, Ext, Misc\2008 Product Reports\08-Aug\[08-23-08 PRODRPT.XLS]CFPRODRPT082608'!$D$3:$F$19,3) The part I would like to change is the $3 and $19 part of the formula. I would like these pieces to reference cells within the spreadsheet. IE: $D(P5):$F(Q5). I have tried things like $D"P5" and $D"& P5 &" to no avail. Any help would be greatly appreciated. -- David Stampor |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sum a column range basing on financial year. | Excel Discussion (Misc queries) | |||
| Search a value basing on another value | Excel Discussion (Misc queries) | |||
| Basing one combo box on another | Excel Discussion (Misc queries) | |||
| Basing Average function range on Date? | Excel Discussion (Misc queries) | |||
| formula to calculate the average of a range basing on condition | Excel Worksheet Functions | |||
Threaded Mode
