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

Solved/Closed

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

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

If one cell contains a name then?..HELP.HELP.
Conditional formatting if cell contains text - Excel Forum
If cell contains date then return value ✓ - Excel Forum
Excel "IF" function w/ date in test cell ✓ - Excel Forum
Excel formula to check if cell contains a date - Excel Forum
If cell A1 has text then cell B2 has today's Date ✓ - Excel Forum

1 response

Answer 1 / 1

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

=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,

Neil
Aug 21, 2010 at 06:46 AM

Thankyou nery much. It works a treat. Really appreciated.thx

Similar discussions

Excel - IF function with multiple words

Counting cells containing only numbers

If cell = date return yes or no.

If a cell contains any text then add a value

How to use conditional format based on text?

Similar discussions

Subscribe To Our Newsletter!