nesting if's/vlookups in complex functions

I have a table of sales taxes based on zip code plus 4.

Worksheet 1
Column A = 5-digit zip
Column B = low end of 4 digit zip
Column C = high end of 4 digit zip
Column D = Sales Tax Juristiction Code

Worksheet 2
Column A = Customer ID
Column B = 5 digit zip
Column C = +4 zip

I need to look at the zip on Worksheet 2
go to worksheet 1 and match the correct zip code
find =>low end +4 and <= high end +4 from worksheet 1

return the correct Sales tax juristiction rate from Worksheet 1 to worksheet 2 for each customer ID

Can anyone tell me how to get started?

I have a table of sales taxes based on zip code plus 4.

Worksheet 1
Column A = 5-digit zip
Column B = low end of 4 digit zip
Column C = high end of 4 digit zip
Column D = Sales Tax Juristiction Code

Worksheet 2
Column A = Customer ID
Column B = 5 digit zip
Column C = +4 zip

I need to look at the zip on Worksheet 2
go to worksheet 1 and match the correct zip code
find =>low end +4 and <= high end +4 from worksheet 1

return the correct Sales tax juristiction rate from Worksheet 1 to worksheet 2 for each customer ID

Can anyone tell me how to get started?

First of all, is there a logical reason for splitting the +4 zip into 2 columns? If you can make that one column it would make using a vlookup statment much easier.

The Zip +4 that comes from the state is already split into two columns. The reason is basically because you are looking for a low end and a high end on the +4 part of the zip. There are already 11,000 rows for the zip code table using the split columns. If there was a single row for every single (full 9-digit) zip+4 combo the worksheet would be unbelievably long.