G Guest Jul 18, 2007 #1 If you delete a row in a master worksheet can you program VLOOKUP to also update the linked worksheets?
If you delete a row in a master worksheet can you program VLOOKUP to also update the linked worksheets?
G Guest Jul 18, 2007 #2 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
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
