This is supposed to be possible right and better than naming each single cell?

How do you do it?

Also, maybe my approach is wrong as it's going to lead to a very big nested IF statement.

There is a list of numbers which are price ceilings and another list of numbers containing the fees applied to these. I want to a formula that checks the item price against the ceilings and if it's less than or equal to that ceiling uses the fee in the adjacent row (which is the other data range).

The only way I know how to do this is a big nested IF statement but does anyone know better?

You will need an if statement no matter what, but it's best if you post on example of what you want.

Here, maybe this is an idea:
http://www.mediafire.com/?z2dyjmtyhmy

Thanks for the idea, but I just wanted a column with net price without writing a huge nested IF statement full of absolute references. I will do that now tho.

I defined named for the ranges to make it less ugly which it says you can access the cells via but it doesn't tell you how.

I don't know if you can advertise other forums here but there is a great one for oo.

Here is something for UK eBay seller, your items are on sheet 2 (up to you to make them pretty )

http://www.mediafire.com/download.php?qwgm3nzjjt0