Provide some examples about your data and how would you like to get the result€¦

--------------------
(Ms-Exl-Learner)
--------------------



"Gridlock" wrote:

I'm trying to find a way of displaying the content of a cell as either a
number or a percentage depending on the output from a lookup. I'm struggling
to find a way to do this in Excel 2003. Can you help please?