Vlookup or similar formula on range between columns

[ks49506]

Greetings -
I've seen a few questions get close but return what I am looking for but not exact.
I have a sheet with ranges of zip codes, columns A and B, and a transit time in C. So if a zip code is found in A, B or between then the transit time is C. A zip code not found in A, B or between it is not serviced.

[TABLE="width: 600"]
<tbody>[TR]
[TD]Start Zip[/TD]
[TD]End Zip[/TD]
[TD]Service Days[/TD]
[/TR]
[TR]
[TD="align: right"]14020[/TD]
[TD="align: right"]14021[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]14024[/TD]
[TD="align: right"]14028[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]14029[/TD]
[TD="align: right"]14029[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD="align: right"]14030[/TD]
[TD="align: right"]14038[/TD]
[TD="align: right"]1[/TD]
[/TR]
</tbody>[/TABLE]

I have a lookup sheet to get the transit time for the zip code plugged in by a user.
[TABLE="width: 249"]
<tbody>[TR]
[TD]Destination ZIP[/TD]
[TD]Transit[/TD]
[/TR]
[TR]
[TD]49506[/TD]
[TD](Return)[/TD]
[/TR]
</tbody>[/TABLE]

If the zip codes is not serviced (it is not in column A, B or between) then the return should be Blank or "Not Serviced" (whatever is fine). I'll probably write an IfError formula around it.

I've tried =IFERROR(VLOOKUP(B6,Sheet1!A:C,3,TRUE),"") but is returning results for zip codes that are not covered in A, B or between.
For example, if I type in 14023, it returns "1" when 14023 is not listed or in a range.

I have non-tech savvy folks using this sheet - I would rather not use an array.

Thanks for the help!

 

[iggydarsa]

=IF(SUMPRODUCT(--(B6>=Sheet1!A:A), --(B6<=Sheet1!B:B), Sheet1!C:C)=0, "Not Serviced", SUMPRODUCT(--(B6>=Sheet1!A:A), --(B6<=Sheet1!B:B), Sheet1!C:C))

 

[ks49506]

What do the dashes mean? I am getting an error

 

[iggydarsa]

Double dash makes the Boolean value in the parenthesis numeric. For example, if the value of "B6>=Sheet1!A:A" is True then it converts to 1. And it converts False to 0.
If you are getting error, please make sure the ranges and the sheet names are correct and you don't forget any parenthesis.

 

[ks49506]

Disregard, I figured it out. Thanks!!! This works!~