View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Angie G.[_2_] Angie G.[_2_] is offline
external usenet poster
 
Posts: 8
Default If statement 08/20/09

Can someone help?

I have a workbook with 2 spreadsheets. 1 sheet is data and the other is the
report.

Both sheets have Rig no., Income and Expense Columns. I want a formula in
the report spreadsheet, to go to data spreadsheet and get corresponding
Income and/or Expense amount to corresponding Rig no; because same rig no.
may be listed several times on the report spreadsheet.

Thanks,