Drop-down Help!

[SimpeGuy84]

Hi,

Best to explain with what I've got.

Sheet 1:
Hospital Score
A 1
B 2
C 3
D 4
E 5

On Sheet 2, I want to select a hospital from a drop down list (I know how to create drop down lists) (e.g. choose C) but instead of returning the value "C" when I select it, I want it to return the value "3" in the cell I'm selecting the drop down.

Is this possible?

[Kyle123]

Not without introducing code.

Why don't you have the score displayed in the cell next to it, then use VLOOKUP?

[SimpeGuy84]

How do I display the score next to it?

I didn't do that for the sake of presentation...

[Kyle123]

Something like

=Vlookup(ValidationCell,'Sheet1'!$A$1:$B$5,2,False) 

[SimpeGuy84]

Erm....

[Kyle123]

Like this:

[SimpeGuy84]

Ok got that

But can you still show me the solution for the first way?

[Kyle123]

Put this in the code behind sheet2. Right click on the tab > view code > Paste the below

This is based on my example

Please Login or Register  to view this content.