I have an excel workbook with 2 tabs. County & RF. Both of these contain address ranges.
Ultimately - I need to have a sheet that includes the address ranges, street name, zip code & school path (ES, MS, HS).
I would like to have a one column that matches the Roadname (county tab) and the Streetname (RF tab)
1 column that will select the lower of the LowAddress (County) & Low (RF), higher of the HighAddress (County) & High (RF)
then include the city & zip (from the County tab) corresponding with the address
and also include the ES, MS & HS columns (From the RF tab).
I'm not even sure this is possible, but I cannot seem to figure it out on my own. I am not an expert in excel, but I'm trying to learn. 🙁
I have added the file as an attachment.....
There is no attachment. Please try again and press the 'Start upload' and wait until finished, before you submit your reply.
I apologize - I thought it has loaded. I have now added it to the thread.
Thanks for the file. That helps 🙂 No apologies needed!
But now, please can you give some examples of the expected results. I'm not 100% sure that I understand the selection criteria.
Or perhaps you can confirm that the following is correct for RAPID CITY, 1 ST.
| LowRange | HighRange | Street | City | Zip | ES | MS | HS |
| 615 | 733 | 1 ST | RAPID CITY | 1899 | SP | SMS | CHS |
and please confirm that RAPID CITY is not the same as RAPID CITY EAST for this exercise.
