formular result to display text from another sheet
 

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

formular result to display text from another sheet
 

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

formular result to display text from another sheet
 

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