How to do in excel

Closed
luis - Jan 23, 2011 at 02:19 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jan 27, 2011 at 08:49 AM
Hello,

I've four columns: A (with Names), B (with date of birth), C(random name of column A) and D (the result i want automatically).
What formula should i use in column D in order to find result of column B.

Example, if A3 is John and B3 is 05-March-1997, if i put in column c7(John) how to do automatically to have in cell D7, 05-March-1997?

I don't want to use Lists with index and match.
Any help?
Thank you in advance.



1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jan 27, 2011 at 08:49 AM
Use VLOOKUP
0