Try something like this:
=VLOOKUP(SUM(C4:C12),Sheet2!A:B,2,0)
formatted as currency to taste,
where the other sheet is Sheet2
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Dan" wrote:
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