Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
HLOOKUP static cell reference
I currently have a HLOOKUP set up as follows
=HLOOKUP(A$1,'G:\SC\Projects\Data\[All.xlsx]Sheet1'!$A$1:$BY$150,ROWS($1:3),0) This allows me to drag the formulae and have the row change accordingly, however the file is references is likely to change. Is there a way of putting the file location, worksheet and range in to cell(s) and have the HLOOKUP reference those cells for the locations, rather than changing the details in a lot of forumlae whenever the references change? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
HLOOKUP static cell reference
Look in the help index for INDIRECT or use editreplace
-- Don Guillett Microsoft MVP Excel SalesAid Software "dewheatley" wrote in message ... I currently have a HLOOKUP set up as follows =HLOOKUP(A$1,'G:\SC\Projects\Data\[All.xlsx]Sheet1'!$A$1:$BY$150,ROWS($1:3),0) This allows me to drag the formulae and have the row change accordingly, however the file is references is likely to change. Is there a way of putting the file location, worksheet and range in to cell(s) and have the HLOOKUP reference those cells for the locations, rather than changing the details in a lot of forumlae whenever the references change? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
in formula a range cell reference eg) $A1:$A20 that is static whenfilling | New Users to Excel | |||
using hlookup, I need the cell reference to add consec # to next | Excel Discussion (Misc queries) | |||
How to specify a static cell reference | Excel Discussion (Misc queries) | |||
cell reference from hlookup | Excel Worksheet Functions | |||
Static cell reference | Excel Worksheet Functions |