formular result to display text from another sheet

[Dan]

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

 

[Max]

Try something like this:
=VLOOKUP(SUM(C4:C12),Sheet2!A:B,2,0)
formatted as currency to taste,
where the other sheet is Sheet2

 

[Bernard Liengme]

Have a look in Help at VLOOKUP then come back if more info is needed
best wishes