Hi all,

I am trying to combine the IF and lookup functions in Excel 2010.

Essentially I have award criteria values of 1-5 in cell a1 selected from a drop down list. Each value has a description attached to it (1 = very poor, 2 = poor etc) that I need to be displayed in cell c1. So if value 1 is selected in cell A1, cell C1 automatically populated is 'poor' and so on.

Can anyone help?

Many thanks

Daithi