Simple Excel spreadsheat help

[furrry]

this is probably very simple for anyone who knows their way around excel

i want to create a dropdown list from which i can choose a preset value,when i choose this value i want the spreadsheet to display next to this value in a seperate
cell/cells the results of this certain value which wont change as each value i enter will have its own preset results.

for example

choosing preset value 1 will show results aaaa,bbbb,cccc
and value 2 will have a different result dddd,eeee,ffff ...etc

would be nice if it could also allow me to enter any of the above results to show which value it belongs to

needs to be contained within the single worksheet but the data can be invisible,or hidden only need the drop down boxes for the value and results to show

anyone help or guide me to a good tutorial for this

thanks

furrry

[cassy34]

Hey Furry,

First off you'll need to sort out the dropdown list box.

In the cell of choice, select Data > Validation from the menu.
In the Allow dropdown, select List and then define the content of the list. This can be in a hidden area of the spreadsheet.

In the cell next to it, you'll need to enter a VLookup formula. In the area you've entered the list, in the cells to the left, put the entries you want to appear when selected

For illustration, the dropdown is in A1 and the range of values is C16

In the cell next to the dropdown (B1), enter the formula

=VLOOKUP(A1,C16,2,0)

You may need to wrap an IF statement around this in case the cell is blank

=IF(ISNA(VLOOKUP(A1,C16,2,0)),"",VLOOKUP(A1,C16,2,0))

Hope it makes sense, off to bed now, I'll look again in the morning

The Smileys are ColonD

[furrry]

hi m8 thanks for your reply

not getting anywere with the formula

i have attached a sample of what i am trying to do, although it will have a few more teams to add later
Attachment 19170

any help you can provide greatly appreciated

furrry

[cassy34]

I see what you're getting at now.

Watch this space.

[furrry]

all sorted now

thanks