View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Constantin Nechita Constantin Nechita is offline
external usenet poster
 
Posts: 1
Default Need Help with Excel Cross Reference Formula

<iframe src="https://skydrive.live.com/embed?cid=87BFEF5915117221&resid=87BFEF5915117221% 21140&authkey=ACNmeSkCm_L_shM&em=2" width="402" height="346" frameborder="0" scrolling="no"</iframe

This is an small project of mine.In the "bank data" sheet there are some bank transactions,in "table" sheet there are two tables :In the first one there are banking amounts for specific dates(b5:h5) for specific shops (a6:a7);in the second table I want to put the amount from "bank data" from col D in K6:Q7 having as reference the date from col C and shop no from col B from "bank data" sheet.
The purpose of this is to try in matching the amounts from K6:Q7 with B6:J7..

Thanks in advance.