Hi

Remove Data Validation from column C and F on Sheet APP Groups
Use the following formula in cell C3
=IF(B3="","",VLOOKUP(B3,'APP Sheets'!C:D,2,0))

Copy as appropriate to other cells as required.

--
Regards
Roger Govier

"mj_bowen" wrote in message
...
Hi,

Basically if any of the names is selected in any of the drop down cells,
then the score that is next to that cell eg, 1a,2b, 3c, 4c is shown next
to
the appropriate name in the APP sheets tab!

I have attached a copy of the worbook;
http://www.box.net/shared/hxr0isxpfi

I've tried all sorts but can't seem make it work!

Matt

This thread is also posted on
http://www.mrexcel.com/forum/showthr...=1#post2202650

__________ Information from ESET Smart Security, version of virus
signature database 4832 (20100203) __________

The message was checked by ESET Smart Security.

http://www.eset.com




__________ Information from ESET Smart Security, version of virus signature database 4832 (20100203) __________

The message was checked by ESET Smart Security.

http://www.eset.com