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

Solved/Closed
Related:

- If one cell contains a name then?..HELP.HELP.
- If cell contains date then return value ✓ - 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
- Excel conditional formatting if another cell contains specific text ✓ - Excel Forum
- If cell contains (multiple text criteria) then return (corresponding text criteria) ✓ - Excel Forum

## 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

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,

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

Aug 21, 2010 at 06:46 AM