Have Excel enter various values based on weight

**marknorton** · 05-30-2007, 07:48 AM

Hi All

I've attached a sheet for anyone who may be able to help with this one, its way above my head!

In the sheet 'Master Stock' I have the weight entered for a product. In the cells to the right, I wish to insert data from the sheet 'Shipping Table'.

In the shipping table sheet, there are prices for various postage services, based on the weight of the item. What I would like to do is have this information pulled into the Master Stock sheet. So for example in Cell DM2, I'd like the price for something which weighs 0.142kg sent by 1st Class Standard post, then the same item by 1st Class Recorded in cell DO2. I guess it uses some form of VLOOKUP command, but taking the weight into consideration is whats throwing me! It needs to use to correct row of data which is relevant to the weight og the item.

As ever, any help would be appreciated beyond belief. I'm 1 stop from doing it manually!

Kind Regards
Mark

**sweep** · 05-30-2007, 07:59 AM

Hi,

I think this is what you're after - let me know?

In Master Stock, DM2, enter this:

=INDEX('Shipping Table'!$C$4:$C$17,MATCH('Master Stock'!H2,'Shipping Table'!$A$4:$A$17,1))

and copy down.

For all the other shipping rates, change the C:C references in the INDEX formula.