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   Aug-31-2014
post by Emanuel Borg:
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!

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
9Street nameStreet no.Need formula that finds the following post codes from list above
10Abc road27123 46City
11Abc road53123 46City
12Abc road119123 47City