Sunday, August 31, 2014

yogi_Extract Information For Specified Street Numbers From A Table Of Street Name Ranges

                      Google Spreadsheet   Post  #1744
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Aug-31-2014
post by Emanuel Borg:
(https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/HzGrIBPuNl8)
Multiple index/match/lookup ? - Simple idea, but I can't find a solution
Hi, I've reached my Spreadsheets knowledge limit. Does anyone have an idea what kind of formula I could use to extract the correct Post code (column D) based on the Street name (column A) and whether the street number is odd/even and between the numbers in columns B and C. See exemple below:

Thanks a lot for any tips!
/Manne

ABCDE
1Street nameStreet no. fromStreet no. toPost codeArea
2Abc road19123 45City
3Abc road28123 45City
4Abc road1052123 46City
5Abc road11115123 46City
6Abc road54120123 47City
7Abc road117227123 47City
8
9Street nameStreet no.Need formula that finds the following post codes from list above
10Abc road27123 46City
11Abc road53123 46City
12Abc road119123 47City

------------------------------------------------------------------------------------------------------------------------