EXCEL 2007

Please refer to:-

http://www.pierrefondes.com/

Item number 93.

In Sheet1 in cells A2 to A6 entry of any one of these numbers:-

200 / 400 / 500 / 600

- will return, respectively, any one of:-

60 / 10 / 10 / 20

- in cells B2 to B6.

The, "conversion table" is found on Sheet2.

Just amend the Workbook to suit your requirements.

If my comments have helped please hit Yes.

Thanks.












I'm not sure if this would be a look up formula, but is there a formula where
I can type in a number in one cell and in the cell next to it, it will pop up
a description that i've written in another cell connected to that number on
another sheet?