Selection list to format following cells

[Woody3ER]

Hello

I would like to create a spreadsheet that allows me to have a drop down list (in this case I diagnosis - from a list of shoulder, knee and ankle). I have used data validation to do this part. I would like to then have the next column automatically select the appropriate outcome measure (shoulder = DASH, Knee = Berg balance, Ankle =BPI) and display this next to the diagnosis and in the final outcome measure box. I would then like this to limit the possible entry details for the score boxes both at initial assessment and final (see D14, D15, D16 respectively).

I hope that makes sense - I have attached a work sheet too

Many thanks

OP outcome measures.xlsx

[$hivasopa]

Check the attached sheet whether this fulfill ur requirement or not.


$hiv

[morevijay1982]

USE IN CELL B3
OK
Shoulder =+VLOOKUP($B3,$B$14:$C$16,2,0) =+VLOOKUP($C3,$C$14:$D$16,2,0) =C3 =+MID(D3,3,4)

[Woody3ER]

Thank you both for your replies - I haven't used VLOOKUP before, so your help has been excellent. I think I am sorted with this bit now.

Thanks again