Hi,
I am using VLOOKUP functions throughout my workbook that looks at the
last worksheet which contains equipment costs. An example is:

=IF(B30<"",IF(ISERROR(VLOOKUP(B30,'Equipment
Costs'!$A$2:$D$895,4,FALSE)),"No Match",VLOOKUP(B30,'Equipment
Costs'!$A$2:$D$895,4,FALSE)),0)

The problem is that I often update my equipment costs worksheet, which
then could grow or decrease in size. Then the range for the hundreds
of VLOOKUP functions are incorrect. Is there a way instead of using
the range 'Equipment Costs'!$A$2:$D$895, I could change the formula to
one cell that will define the range? When I type a cell reference in
the VLOOKUP function, it won't use that cells value for the range.
Excel is looking at it as the range. Any ideas? Thanks in advance!
Scott


--
sep1280
------------------------------------------------------------------------
sep1280's Profile: http://www.excelforum.com/member.php...o&userid=32175
View this thread: http://www.excelforum.com/showthread...hreadid=519237