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.
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.