Hi,

I have data in two sheets in one work book sheet A and Sheet B. I use Vlookup to for Data in Sheet A to be shown in sheet B. but if u change any column in sheet A, the formula in Sheet B doesnt update and picks up the wrong column. How can i fix the columns so that even i add or delete any rows from my master sheet, the formula automatically update?

even i add or delete any *columns from my master sheet, the formula automatically update?

You can use the INDEX+MATCH function instead of VLOOKUP.

http://www.mbaexcel.com/excel/why-index-match-is-better-than-vlookup/