VLOOKUP Formula

J

Jackie

If you delete a row in a master worksheet can you program VLOOKUP to also
update the linked worksheets?
 
M

Mike H

Jackie,

If you have a vlookup on sheet 2 looking at sheet 1 such as

=VLOOKUP(A2,Sheet1!A$1:B$15,2,FALSE)

Deleting a row in iin the range A1 to B15 wont change the formula.

However, if you use

=VLOOKUP(A2,myrange,2,FALSE)

The myrange in the formula shrinks/expands as you add/delete rows.

Mike
 
Top