If one cell contains a name then?..HELP.HELP.

Neil - Aug 14, 2010 at 10:37 AM
 Neil - Aug 21, 2010 at 06:46 AM

I have a 2 columns in (Worksheet 1) . One with Names (A1) and the other with Numbers (B1) corresponding to the names. On (Worksheet 2) (C1) I have a drop down list of the names in (Worksheet 1)(A1). I now want another cell in (Worksheet 2)(D1) to automatically look at cell (C1) and then fill in the corresponding number that is listed in (B1). Hope this makes sense...

Bates Sarah (Mrs) R4376588
Crooks Evelyn (Mrs) R4376589
England Eddie (Mr) R4376590




1 response

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Aug 15, 2010 at 06:54 AM
in D1 in the second sheet copy this formula


if you choose any name in the validation list in C1 automatically D1 will give corresponding number,
Thankyou nery much. It works a treat. Really appreciated.thx