Bit light on detail. Essentially it is

=(A1=1,Sheet2!A1,IF(A1=2,Sheet2!B1,IF(...)))

--
HTH

Bob Phillips

"Annerobbo" wrote in message
...
Hi

I need to write a formula that if a cell on a worksheet contains a number
a
cell on a different worksheet within the workbook returns a different
number.
There are 5 different numbers - can someone help please.

Thanks in advance

Anne