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.
If cell contains text then return value in another cell ✓ - Excel Forum
If cell contains (multiple text criteria) then return (corresponding text criteria) ✓ - Excel Forum
Excel if cell color is red then - Guide
How to re/name a cell if another cell contains X ✓ - Excel Forum

1 reply

Answer 1 / 1

venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 810
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

How to use conditional format based on text?

Counting cells containing only numbers

If cell = date return yes or no.

Highlight cell if another cell contains any text

Excel if range of cell contain a text put a cell value in

Similar discussions

Subscribe To Our Newsletter!