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.
Count if cell contains number - Excel Forum
If cell contains date then return value - Excel Forum
If cell A1 has text then cell B2 has today's Date ✓ - Excel Forum
If cell contains (multiple text criteria) then return (corresponding text criteria) ✓ - Excel Forum
Based on the cell values in cells b77 ✓ - 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

If a cell contains any text then add a value

If cell = date return yes or no.

Highlight cell if another cell contains specific text

Excel: If Date =, then enter a value

Excel "IF" function w/ date in test cell

Similar discussions

Subscribe To Our Newsletter!