jleasure457
New Member
- Joined
- Dec 27, 2018
- Messages
- 9
- Office Version
- 365
- Platform
- Windows
Hello,
I am in need of a formula that can lookup up a zip code from a cell and reference the correct rate based off of the table below. The way the table below works is that any zip code equal to or less than the given zip code correlates to that rate. So for example, anything zip code less than or equal to 90213=1.5. Zip codes greater than or equal to 90214 or less than or equal to 90219 = 1. The formula would need to look up a zip code on another table and, reference the below table, and return the correct rate based on where the given zip code falls within the range described.
I am in need of a formula that can lookup up a zip code from a cell and reference the correct rate based off of the table below. The way the table below works is that any zip code equal to or less than the given zip code correlates to that rate. So for example, anything zip code less than or equal to 90213=1.5. Zip codes greater than or equal to 90214 or less than or equal to 90219 = 1. The formula would need to look up a zip code on another table and, reference the below table, and return the correct rate based on where the given zip code falls within the range described.
ZIP_CODE | RATE |
90213 | 1.5 |
90219 | 1 |
90224 | 1.5 |
90229 | 1 |
90233 | 1.5 |
90238 | 1 |
90242 | 1.5 |
90244 | 1 |
90245 | 1.5 |
90246 | 1 |
90251 | 1.5 |
90253 | 1 |
90255 | 1.5 |