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

Closed
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.

Adit!

1 reply

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
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 https://authentification.site and post back here the link to allow better understanding of how it is now and how you foresee.
0
Pls give me some time to do this. Thank you.
0