I need to know the date and time from column I to go into column N based on the criteria in L and M. i have attached a sample book to see what i mean.Book 1.xlsx
Thanks in advance for any help
Last edited by rclose; 02-07-2012 at 04:03 PM.
in N3 enter
=INDEX($I$3:$I$15,MATCH(L3&M3,$C$3:$C$15&$F$3:$F$15,0)) and enter with Ctrl + Shift
To thank someone who has helped you, click on the star icon below their name.
I hate reading
Portfolio
I need a job.I am young and incompetent
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks