variable sheet reference lookup

[DrJimmy]

Hi,

I want to do a vlookup that will look in a worksheet depending on the value of a cell.

eg cell A1 is zone number, say 3.

i have 8 worksheets in the file called Zone 1, zone 2 etc.

So I would want the lookup to refer to sheet Zone 3 based on the value in cell A1.

Is this possible, and if so help please?!

Cheers

 

[qafself]

Yes, you can do this using the INDIRECT function

Regards

 

[DrJimmy]

would you be able to give me an example? The INDIRECT function is unfamiliar to me and I'm not having much luck. The online help isn't doing much for me either!

Cheers

 

[qafself]

Small example attached - post back if this is not what you need, if you can attach an example of your book that would make things easier

Ed

 

[DrJimmy]

That works a treat. Thanks for you help.

 

[qafself]

No problem.

Thanks for the feedback

Ed