boggis2000
New Member
- Joined
- Feb 2, 2004
- Messages
- 3
Hi everyone, another newbie and my first post!
I am still fairly new to Excel but not stupid, and have a small problem. The problem arises when using the function VLookup and the formula is:
=VLOOKUP(B10,dA!A4:J4,4,FALSE)
The function looks up values in an array from another sheet called dA. I want to be able to select different sheets where the values are looked up from, so it is not always dA. (I want dB, dC etc...)
I have created a validation cell which contains a list of the sheets' names but can't incoporate it into the formula. It would be good if I could select the sheet from the list in the cell (ie dA, dB) and then the value in the cell is used in the function.
Also, can I automatically have sheet names listed in the validation cell instead of typing them in manually?
Please fell free to ask questions as I'm finding it a problem decribing the situation!!
I am still fairly new to Excel but not stupid, and have a small problem. The problem arises when using the function VLookup and the formula is:
=VLOOKUP(B10,dA!A4:J4,4,FALSE)
The function looks up values in an array from another sheet called dA. I want to be able to select different sheets where the values are looked up from, so it is not always dA. (I want dB, dC etc...)
I have created a validation cell which contains a list of the sheets' names but can't incoporate it into the formula. It would be good if I could select the sheet from the list in the cell (ie dA, dB) and then the value in the cell is used in the function.
Also, can I automatically have sheet names listed in the validation cell instead of typing them in manually?
Please fell free to ask questions as I'm finding it a problem decribing the situation!!