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

Closed
Adit - 5 May 2010 à 08:47
 Adit - 5 May 2010 à 09:14
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.

Adit!

1 response

rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
5 May 2010 à 08:55
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 https://authentification.site 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.