Column A = Shipment Type (ie. NDA comm, NDA resi, NDAsaver, etc.)
Column B = Package weight
Column C = Package ship to Zone
I am trying to create a spreadsheet that will look up princing based on both the weight and zone for shipping:
=VLOOKUP(B2,'[UPSRates2008.xls]NDA comm'!$A$8:$K$159,MATCH(C2,'[UPSRates2008.xls]NDA comm'!$A$8:$K$8,FALSE),FALSE)
NDA comm is the sheet in the workbook that has the rates for NDA (Next Day Air)
The 8th row in the above sheet matches my zone.
Based on my level on Excel, I was happy with that, because it works.
Next, I want it to look in column A and have my lookup go to the appropriate table. For instance, if it say "NDA comm" then I want it to go to tab NDA comm to look up the rate. I can do this for if statements and look up 7 different rate tables, and I'd like to go to 10.
I used named ranges to simplify my vlookup. I tried linking to A2 hoping it would recognize that as the named range, but then Excel thinks that I'm just pointing to my range (which is only one cell). I don't blame Excel, this is user error. Anyone have an idea of how I can have this lookup to 10 rate tables based on the shipment type? I need to do this for MANY different companies, so manually changing for each company will take too much time.
Thank you in advance. I hope my question is clear and I always appreciate the help on this board.
Best regards!
Column B = Package weight
Column C = Package ship to Zone
I am trying to create a spreadsheet that will look up princing based on both the weight and zone for shipping:
=VLOOKUP(B2,'[UPSRates2008.xls]NDA comm'!$A$8:$K$159,MATCH(C2,'[UPSRates2008.xls]NDA comm'!$A$8:$K$8,FALSE),FALSE)
NDA comm is the sheet in the workbook that has the rates for NDA (Next Day Air)
The 8th row in the above sheet matches my zone.
Based on my level on Excel, I was happy with that, because it works.
Next, I want it to look in column A and have my lookup go to the appropriate table. For instance, if it say "NDA comm" then I want it to go to tab NDA comm to look up the rate. I can do this for if statements and look up 7 different rate tables, and I'd like to go to 10.
I used named ranges to simplify my vlookup. I tried linking to A2 hoping it would recognize that as the named range, but then Excel thinks that I'm just pointing to my range (which is only one cell). I don't blame Excel, this is user error. Anyone have an idea of how I can have this lookup to 10 rate tables based on the shipment type? I need to do this for MANY different companies, so manually changing for each company will take too much time.
Thank you in advance. I hope my question is clear and I always appreciate the help on this board.
Best regards!
