View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
dan dan is offline
external usenet poster
 
Posts: 866
Default 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