Excel Help Please

[smiffy]

I have a sheet with weights in Column F. On another sheet I have the Royal Mail postage table

up to
60g 28p
100 42p
150 60p
200 75p
250g 88p
etc etc

How do I get the postage cost into Column G on the first sheet?

[tunes]

Copy and paste ?

Or alternatively...

Just say in Location 1F you have "60g" and on Sheet2 in location 1J you have the "28p" value... in sheet1 in box 1G (wherever you want the value) enter "=Sheet2!J1" (without quotes)

the format is basically =sheetnumber!gridlocation (in ColumnRow format, rather than RowColumn format).

Is this what you mean ?

HTH.

[danielgarton74]

It can be done using a nested if expression like the following:

=IF(F1 < $E$24,$F$24,IF(F1 < $E$25,$F$25,IF(F1 < $E$26,$F$26,IF(F1 < $E$27,$F$27,IF(F1 < $E$28,$F$28,-1)))))

In mine the postage weights are in e25 - e28 and the values in f25 - f28. Note that you need to use absolute coordinates (using a '$') so that this works when you copy it for each line.

Not sure if this is the neatest but it works :)

[Arthur Fowler]

Smiffy - are you saying that you have a list of packages on the first sheet and you want to put the correct postage amount against it based on the values in sheet 2?

If so, then you can use VLOOKUP (can't give you step by step instructions now as I don't have excel at home) to give a slightly neater solution than Daniel's. It is a straightforward function to use. Hit the help key for that function.

You'll need to remove the "g" from the weight column in sheet 2.

Arthur

[smiffy]

thanks - vlookup is the bunny!