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

	A	B	C	D	E
1	Street name	Street no. from	Street no. to	Post code	Area
2	Abc road	1	9	123 45	City
3	Abc road	2	8	123 45	City
4	Abc road	10	52	123 46	City
5	Abc road	11	115	123 46	City
6	Abc road	54	120	123 47	City
7	Abc road	117	227	123 47	City
8
9	Street name	Street no.		Need formula that finds the following post codes from list above
10	Abc road	27		123 46	City
11	Abc road	53		123 46	City
12	Abc road	119		123 47	City

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