Good morning all. I have an Excel spreadsheet with 2 worksheets. Th
first work sheet (worksheet A) I have a list (c2:c284) of names. O
the other worksheet (worksheet B) I have a dropdown box that include
values from the list on worksheet A (data validation:lists). There ar
4 cells in worksheet B that have this dropdown box with the selection o
names.

Here is what I am trying to do...Whenever I select a name from any o
the 4 cells in Worksheet B, I want to place the word \"Selected\" nex
to the value within the list on Worksheet A.

I have been through the mill working with VLOOKUP, MATCH, INDEX, LOOKU
and other functions. Nothing seems to work.

Thanks you all for any and all advice.

:

--
james081
-----------------------------------------------------------------------
james0810's Profile: http://www.excelforum.com/member.php...fo&userid=3639
View this thread: http://www.excelforum.com/showthread.php?threadid=56172