Lookup and Display repeated Data in one single TABLE....

S

Syed Ubaid

I am using Vlook up function in my sheets
I stucked up when I wanted to show the detail
of following table on other sheet of same file.

A B C D
Row# ================================
1 Code Description Debit Credit
================================
2 BA Bank 2500

3 CA CASH 2500
================================
4 AP A/C Payable 1500

5 CA CASH 1500
=================================
6 CA CASH 3500

7 RR RENT REVENUE 3500
================================


The above mentioned table (A1:D7) On Sheet "JV" is defined
range "JVE". Now I want to display the "T-Account" (an
accounting Terminology) to show all the Transactions of
CASH on Debit and Credit side in this T-Account like this:

CASH
-------------------------------------------------
Rent Rev. 3500 | Bank 2500
| A/c Pay 1500
|
|
|
|

Note that VLOOKUP function look up for ONE/SINGLE match
Any possiblity to show the data of Table in this manner.

Syed
 
Top