Spreadsheet: 55350d1255471510-vlookup-and-workbook-sheet-referencing-in-2007-book2
Sheet: Sheet1

Service | Standard |  |  | Type Weight in Here | Carrier | Rate |  |  | [NAME]
[NAME] in Here -----> |  | 24563 |  | 350
Zone #
Zone Transit Time |  |  |  |  |  | I need the information in sheet 2 to show up when the information is entered into cells c2 and e2,,,,, I already have the formulas for cell
Beyond - Add Day(s) |  |  |  |  |  | f2 I just need g2 to work,,,, I cant get it to work, ,,,,,,basically it should be like this I enter the zip and type in the weight hit enter and it will tell me what carrier use  and the rate  in cell G2 which is in sheet 2,,,,,, like I said I have the carrier formula but I don’t know how to reference sheet 2 for cell G2
Expected Transit Time |  |  |  |  |  | Oh,,,the rate is based of the weight as seen here below
 |  |  |  |  |  | none of the formulas work because I had to copy and past and not all the actual data is here for these formulas to work but im only worried about the rate one
 |  |  |  |  |  | but this is the are on page to that I need to reference from sheet 2 into cell g2 go to sheet 2
[NAME] | [NAME] | Zone | Beyond | Zip Market | State | 200 | 250 | 300 | 350 | 400 | 450 | 500 | 550 | 600 | 650 | 700 | 750 | 800 | 850 | 900 | 950 | 1000 | 1050 | 1100 | 1150 | 1200 | 1250 | 1300 | 1350 | 1400 | 1450 | 1500 | 1550 | 1600 | 1650 | 1700 | 1750 | 1800 | 1850 | 1900 | 1950 | 2000 | 2050 | 2100 | 2150 | 2200 | 2250 | 2300 | 2350 | 2400 | 2450 | 2500 | 2550 | 2600 | 2650 | 2700 | 2750 | 2800 | 2850 | 2900 | 2950 | 3000
48653 | 501 | 2 | 0 | MID-ISLAND NY 005 | NY | Con-way | FedEx  Frt | UPS  Frt | R+L | Old Dom | Estes | USF Holland | Saia | Con-way | FedEx  Frt | UPS  Frt | R+L | Old Dom | Estes | USF Holland | Saia | Con-way | FedEx  Frt | UPS  Frt | R+L | Old Dom | Estes | USF Holland | Saia | Con-way | FedEx  Frt | UPS  Frt | R+L | Old Dom | Estes | USF Holland | Saia | Con-way | FedEx  Frt | UPS  Frt | R+L | Old Dom | Estes | USF Holland | Saia | Con-way | FedEx  Frt | UPS  Frt | R+L | Old Dom | Estes | USF Holland | Saia | Con-way | FedEx  Frt | UPS  Frt | R+L | Old Dom | Estes | USF Holland | Saia | Con-way
48653 | 544 | 2 | 0 | MID-ISLAND NY 005 | NY | Con-way | FedEx  Frt | UPS  Frt | R+L | Old Dom | Estes | USF Holland | Saia | Con-way | FedEx  Frt | UPS  Frt | R+L | Old Dom | Estes | USF Holland | Saia | Con-way | FedEx  Frt | UPS  Frt | R+L | Old Dom | Estes | USF Holland | Saia | Con-way | FedEx  Frt | UPS  Frt | R+L | Old Dom | Estes | USF Holland | Saia | Con-way | FedEx  Frt | UPS  Frt | R+L | Old Dom | Estes | USF Holland | Saia | Con-way | FedEx  Frt | UPS  Frt | R+L | Old Dom | Estes | USF Holland | Saia | Con-way | FedEx  Frt | UPS  Frt | R+L | Old Dom | Estes | USF Holland | Saia | Con-way
48653 | 601 | 4 | 0 | SAN JUAN PR 006 | PR | Con-way | FedEx  Frt | UPS  Frt | R+L | Old Dom | Estes | USF Holland | Saia | Con-way | FedEx  Frt | UPS  Frt | R+L | Old Dom | Estes | USF Holland | Saia | Con-way | FedEx  Frt | UPS  Frt | R+L | Old Dom | Estes | USF Holland | Saia | Con-way | FedEx  Frt | UPS  Frt | R+L | Old Dom | Estes | USF Holland | Saia | Con-way | FedEx  Frt | UPS  Frt | R+L | Old Dom | Estes | USF Holland | Saia | Con-way | FedEx  Frt | UPS  Frt | R+L | Old Dom | Estes | USF Holland | Saia | Con-way | FedEx  Frt | UPS  Frt | R+L | Old Dom | Estes | USF Holland | Saia | Con-way
48653 | 602 | 4 | 0 | SAN JUAN PR 006 | PR | Con-way | FedEx  Frt | UPS  Frt | R+L | Old Dom | Estes | USF Holland | Saia | Con-way | FedEx  Frt | UPS  Frt | R+L | Old Dom | Estes | USF Holland | Saia | Con-way | FedEx  Frt | UPS  Frt | R+L | Old Dom | Estes | USF Holland | Saia | Con-way | FedEx  Frt | UPS  Frt | R+L | Old Dom | Estes | USF Holland | Saia | Con-way | FedEx  Frt | UPS  Frt | R+L | Old Dom | Estes | USF Holland | Saia | Con-way | FedEx  Frt | UPS  Frt | R+L | Old Dom | Estes | USF Holland | Saia | Con-way | FedEx  Frt | UPS  Frt | R+L | Old Dom | Estes | USF Holland | Saia | Con-way
48653 | 603 | 4 | 0 | SAN JUAN PR 006 | PR | Con-way | FedEx  Frt | UPS  Frt | R+L | Old Dom | Estes | USF Holland | Saia | Con-way | FedEx  Frt | UPS  Frt | R+L | Old Dom | Estes | USF Holland | Saia | Con-way | FedEx  Frt | UPS  Frt | R+L | Old Dom | Estes | USF Holland | Saia | Con-way | FedEx  Frt | UPS  Frt | R+L | Old Dom | Estes | USF Holland | Saia | Con-way | FedEx  Frt | UPS  Frt | R+L | Old Dom | Estes | USF Holland | Saia | Con-way | FedEx  Frt | UPS  Frt | R+L | Old Dom | Estes | USF Holland | Saia | Con-way | FedEx  Frt | UPS  Frt | R+L | Old Dom | Estes | USF Holland | Saia | Con-way
48653 | 604 | 4 | 0 | SAN JUAN PR 006 | PR | Con-way | FedEx  Frt | UPS  Frt | R+L | Old Dom | Estes | USF Holland | Saia | Con-way | FedEx  Frt | UPS  Frt | R+L | Old Dom | Estes | USF Holland | Saia | Con-way | FedEx  Frt | UPS  Frt | R+L | Old Dom | Estes | USF Holland | Saia | Con-way | FedEx  Frt | UPS  Frt | R+L | Old Dom | Estes | USF Holland | Saia | Con-way | FedEx  Frt | UPS  Frt | R+L | Old Dom | Estes | USF Holland | Saia | Con-way | FedEx  Frt | UPS  Frt | R+L | Old Dom | Estes | USF Holland | Saia | Con-way | FedEx  Frt | UPS  Frt | R+L | Old Dom | Estes | USF Holland | Saia | Con-way
48653 | 605 | 4 | 0 | SAN JUAN PR 006 | PR | Con-way | FedEx  Frt | UPS  Frt | R+L | Old Dom | Estes | USF Holland | Saia | Con-way | FedEx  Frt | UPS  Frt | R+L | Old Dom | Estes | USF Holland | Saia | Con-way | FedEx  Frt | UPS  Frt | R+L | Old Dom | Estes | USF Holland | Saia | Con-way | FedEx  Frt | UPS  Frt | R+L | Old Dom | Estes | USF Holland | Saia | Con-way | FedEx  Frt | UPS  Frt | R+L | Old Dom | Estes | USF Holland | Saia | Con-way | FedEx  Frt | UPS  Frt | R+L | Old Dom | Estes | USF Holland | Saia | Con-way | FedEx  Frt | UPS  Frt | R+L | Old Dom | Estes | USF Holland | Saia | Con-way