date in col a does not match date+ time in col d so it would be n/a
e.g 3/29/2009 real numerical value is 39901
3/29/2009 6:00:00 real numerical value is 39901.25 so no match can be found
Last edited by martindwilson; 06-15-2009 at 03:44 PM.
Mojito connoisseur and a dabbler in Cisco
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
it only worked for b2 which has a time of 6:00. b3 etc still shows as available
no i changed my post as i saw times were not consistent you are going to have to remove them to match date
in your example put
=INT(D2) in cell c2 and drag down
change vlook up to include c (note column change from 2 to 3)
=IF(ISNA(VLOOKUP(A2,C:E,3,FALSE)),"Available",VLOOKUP(A2,C:E,3,FALSE))
Mojito connoisseur and a dabbler in Cisco
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks