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.
<tbody>
</tbody>
I have a lookup sheet to get the transit time for the zip code plugged in by a user.
<tbody>
</tbody>
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!
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.
Start Zip | End Zip | Service Days |
14020 | 14021 | 1 |
14024 | 14028 | 1 |
14029 | 14029 | 2 |
14030 | 14038 | 1 |
<tbody>
</tbody>
I have a lookup sheet to get the transit time for the zip code plugged in by a user.
Destination ZIP | Transit |
49506 | (Return) |
<tbody>
</tbody>
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!