View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ghalmaraz Ghalmaraz is offline
external usenet poster
 
Posts: 6
Default Linking Cells from a different Worksheet with an IF Function

Hi

In my workbook I have two worksheets, one of which includes data from
Access, the other presents it in a more managable way. What I need is a
formula that would link two cells across the worksheets IF the individual
(numbered from 1-22) and the date (in dd/mm/yyyy) meet criteria. Also, the
data is incomplete (in that some months there was no data inputted (when a
zero should have been inputted)) would need to show a 'zero'

Any Ideas?

G