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

Solved/Closed
Report
-
 Neil -
Hello,

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

HELP...HELP


Thx

Neil

1 reply

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
804
in D1 in the second sheet copy this formula

=VLOOKUP(C1,Sheet1!$A$1:$B$100,2,0)

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