Need Help with Excel Cross Reference Formula

  • Thread starter Constantin Nechita
  • Start date
C

Constantin Nechita

<iframe src="https://skydrive.live.com/embed?cid...EF5915117221!140&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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top