Referencing sheets with a drop down menu

[hoops2425]

I'm a novice to the Excel, but here is my issue:

I have a drop down menu that lists all of my page names. Once I select the page names from this menu, I'd like to use that cell for a vlookup or if formula. for example:

A1 B1 C1
List of Pages: OR1000, OR2000, OR3000

If I select OR1000 from the drop down, and then I want to use the following formulat =vlookup(A1,...etc)

I realize i'm asking it to look for a value A1, but I want it to reference the value in question from Sheet "OR1000". I hope that makes sense...don't worry so much what data I want to grab, just how I can reference the data using the drop down menus. thanks in advance.

 

[Robert Mika]

Try INDIRECT:
Excel INDIRECT Function Tutorial

 

[hoops2425]

Thanks for the help. this answers my question perfectly!

 

[Robert Mika]

Thanks for the help. this answers my question perfectly!

You are welcome.