Zip Code Range Lookup, Please help!

[ryan13love]

I have a spreadsheet of data that is tied to zip codes. I have another spreadsheet that contains ranges of zip codes (in separate cells) with values associated to each zip code range. I would like to create a formula to lookup the zip code in the first spreadsheet in the ranges of the second spreadsheet and tell me the associated value. Here is my example.....

Spreadsheet 1: Zip Code: 44092

Spreadsheet 2:
Beginning Value (in only one cell): 44000
Ending Value (in only one cell): 44100
Value of Range: 5

What formula would return the value "5"?

I have a ton of data to this for. Thanks for the help!

 

[Warship]

Do you have two seperate Workbooks
or
One Workbook with two sep Worksheets

 

[ryan13love]

One Workbook with two sep Worksheets

 

[Warship]

Can you post sample data?

 

[Warship]

Is this what you mean?

Excel Workbook
	A	B
1	Zip	LookUp value
2	44092	5
3	44087	0
4	44098	11
Sheet1

Excel 2007

Cell Formulas
Range	Formula
B2	=VLOOKUP(A2,Sheet2!A1:B15,2,FALSE)

Excel Workbook
	A	B
1	zip	value
2	44085	-2
3	44086	-1
4	44087	0
5	44088	1
6	44089	2
7	44090	3
8	44091	4
9	44092	5
10	44093	6
11	44094	7
12	44095	8
13	44096	9
14	44097	10
15	44098	11
Sheet2

Excel 2007

 

[ryan13love]

First Tab

Column A Column B Column C Column D
orginal zip code destination zip code zone code What the code should be
54901 54904 ? (looking up) A
54901 73708 ? (looking up) B

Second Tab
Column A Column B Column C
Zip Code Start Zip Code End Code
54900 55000 A
55001 55100
55101 55200
55201 55300
55301 55400
55401 55500
73501 73600
73601 73700
73701 73800 B