Have a look in Help at VLOOKUP then come back if more info is needed
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Dan" wrote in message
...
I need the result from a formula (total c4:c12) to display a line of text
from another sheet in the same workbook. ie if the result was 80% then the
cell below would display £20 as the list on the other sheet has two
colums,
A2=80% B2=£20

Any help would be greatly recieved