vLookup Help - Global Change

[Snopro711]

I am looking for an easy way to refresh a vlookup formula to point to a different worksheet without modifying each formula.

For instance;
=VLOOKUP ('MASTER SHEET'!A2,'MASTER SHEET'!A2:X567,4,TRUE).

I want to do a global change on these formulas to replace NEW MASTER with all
formula references of MASTER SHEET.

Thanks

[tlafferty]

Just use Edit|Replace and make sure you are looking in formulas...
(CTRL + H)

[Snopro711]

Excellent, thank you for your quick response.

Snopro711

[jeffreybrown]

Just as an option...

If you want to use a cell to hold the sheet reference you could use the Indirect method

http://www.contextures.com/xlFunctions05.html