Vlookup with True request

njbeancounter

Board Regular
Joined
Oct 7, 2002
Messages
158
I have a list of dates and times that represent when a commercial aired.

I have another list with dates and times people called based on the commercial air time.

I want to look up the called time based on the commercial aired time.

When using the vlookup formula, I used "true" to give me the earlier time result, which is in another column, with either a 1 for ordered or a zero for did not order. HOWEVER,

if there were multiple hits, I would get a duplication in my formula result. I almost want to have a formula that only returns the result once, but since

the times are never going to match exactly, I can't opt for the "exact match" option.

Any ideas?
 

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).
Have an time offset.

Say the commercial aired at 22:00.
Search the table for any calls for that commercial that aired for the next 3 minutes so search for times between 22:00 and 22:03.
 
Upvote 0

Forum statistics

Threads
1,224,823
Messages
6,181,181
Members
453,022
Latest member
Mohamed Magdi Tawfiq Emam

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top