Log In
Register
Home
New Member
March 6, 2024
Offline
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.....
Moderators
January 31, 2022
Offline
There is no attachment. Please try again and press the 'Start upload' and wait until finished, before you submit your reply.
New Member
March 6, 2024
Offline
I apologize - I thought it has loaded. I have now added it to the thread.
Moderators
January 31, 2022
Offline
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.
1 Guest(s)
