vlookup table array #ref error

[Difference14]

Hi

This is probably a stupid question but ...

I have several dozen vlookup formula running off a spreadsheet (call it Sheet 4) that is sent in from another department.

If a new Sheet 4 is sent and saved in my folder over writing the old one, I will obviously get a ref error in my vlookup formulas .. but is there a way to avoid this. i don't particularily want to have to re-reference all my formulas for the new Sheet 4.

The format of Sheet 4 will be identical to the old one and my vlookup table array will be the same (Sheet4F:U)

regards

 

[davey4444]

I think that the Indirect function should help you here. Something like indirect("Sheet4!F:U")