Since you're using the exact match switch, you can probably use the
entire column:

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

In article ,
sep1280 wrote:

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