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 ✓ - Office Software Forum
- Excel formula to check if cell contains a date - Excel Forum
- Excel if cell contains text then copy to another sheet ✓ - Excel Forum
- Excel if color cell - Guide
- Insert a function in cell b2 to display the current date from your system. ✓ - 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
=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,
=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