Two ways sort of vlookup, pls help!!!?

Adit - May 5, 2010 at 08:47 AM
 Adit - May 5, 2010 at 09:14 AM
Col A Col B Col C

Jack Kate
1-Apr 7:30 PM 7:30 PM
2-Apr 7:30 PM 7:30 PM
3-Apr 5:30 PM 5:30 PM
5-Apr 7:30 PM 7:30 PM
6-Apr 7:30 PM 7:30 PM
7-Apr 7:30 PM 7:30 PM
8-Apr 7:30 PM 7:30 PM
9-Apr 7:30 PM 7:30 PM

My question is to look up the name like Jack , Kate etc when the enter the formula. but the condition is that only if for example, col c 3 and col a date match it should show the name or else n/a. that means that only if the index time and date match the name shows...Please solve this for me which ever way you can thank you.


1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
May 5, 2010 at 08:55 AM
I find it hard to see what you are getting at. Could you please upload a sample file with sample data etc on some shared site like and post back here the link to allow better understanding of how it is now and how you foresee.
Pls give me some time to do this. Thank you.