Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I format the number in a formular that contain text? | Excel Worksheet Functions | |||
Formula: =PROPER(text), won't display result. | Excel Discussion (Misc queries) | |||
Formatting text in a formular | Excel Discussion (Misc queries) | |||
user form question: text box to display result | Excel Discussion (Misc queries) | |||
user form question: text box to display result | Excel Worksheet Functions |