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.
|