michaeldenna
New Member
- Joined
- Aug 9, 2009
- Messages
- 10
hi guys,
thank you in advance for helping me with my query.
in short I've almost finished my spreadsheet yet I'm stuck on one point.
I created a drop down with 60 different options to choose from. I want to be able to vlookup the selected option from the drop down and retrieve up to 30 results based on that drop down.
e.g a1 is the selected result from the dropdown
=vlookup(a1,a5:b65,2,0).
because there are 30 different bits of info that i want to retrieve as a result of selected the option from the drop down, i figuire i would have the 30 different results sequentially below and offset the result
e.g =vlookup(a1,b5:65,2,0) - cell 1
=offset(vlookup(a1,b5:65,2,0),0,-1) - cell 2
etc,etc for the 30 cells.
I'm in desperate need of help as Im due to hand in this report sometime today.
thanks
michael
thank you in advance for helping me with my query.
in short I've almost finished my spreadsheet yet I'm stuck on one point.
I created a drop down with 60 different options to choose from. I want to be able to vlookup the selected option from the drop down and retrieve up to 30 results based on that drop down.
e.g a1 is the selected result from the dropdown
=vlookup(a1,a5:b65,2,0).
because there are 30 different bits of info that i want to retrieve as a result of selected the option from the drop down, i figuire i would have the 30 different results sequentially below and offset the result
e.g =vlookup(a1,b5:65,2,0) - cell 1
=offset(vlookup(a1,b5:65,2,0),0,-1) - cell 2
etc,etc for the 30 cells.
I'm in desperate need of help as Im due to hand in this report sometime today.
thanks
michael