Ok this is what I need ... Not sure which calculation to use or how to
set up that calculation ...

****If Cell B17 = 1st on Sheet 1 then I need for it to return a vaule
of 50 on sheet 2

****If Cell B17 = 2nd on Sheet 1 then I need for it to return a vaule
on 100 on sheet2

3rd = 150
4th = 200
5th = 250
6th = 300
7th = 350
8th = 400
9th = 450
10th = 500
Stops here .... So one cell would have to contain all the options
above.

I was thinking I should use a database calculation ... But I am not
sure how to set it up ... Can anyone help with this

I would then copy this calcualtion so that it applys to Column B thru K
- Row 17 -26

__________________________________________________ _______________

UPDATE but still need help ....

I can can get the above to work with the IF command but only up to a
point ....

WORKS -

=IF(Sheet2!B17=1,"50",IF(Sheet2!B17=2,"100",IF(She et2!B17=3,"150",IF(Sheet2!B17=4,"200",IF(Sheet2!B1 7=5,"250",IF(Sheet2!B17=6,"300",IF(Sheet2!B17=7,"3 50",IF(Sheet2!B17=8,"400"))))))))


DOES NOT WORK - And this is what I need.

=IF(Sheet2!B17=1,"50",IF(Sheet2!B17=2,"100",IF(She et2!B17=3,"150",IF(Sheet2!B17=4,"200",IF(Sheet2!B1 7=5,"250",IF(Sheet2!B17=6,"300",IF(Sheet2!B17=7,"3 50",IF(Sheet2!B17=8,"400",IF(Sheet2!B17=9,"450",
IF(Sheet2!B17=10,"500"))))))))))

I get the error after "400" - Can anyone help with this? Should I be
using a different command - If so which one? and how do I set it up?


Thanks in advance


--
SVTF
------------------------------------------------------------------------
SVTF's Profile: http://www.excelforum.com/member.php...o&userid=26532
View this thread: http://www.excelforum.com/showthread...hreadid=397993