VLOOKUP

Closed
KISHORE - Aug 21, 2010 at 08:30 AM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Sep 1, 2010 at 06:15 PM
Hello,

IN A1 COLUMN FLAT NUMBERS , B1 COLUMN "RECEIPT NO" AND C1 COLUMN "AMOUNT PAID". IN ANOTHER SHEET I HAVE FLAT NUMBERS IN ROWS LIKE A001,AOO2.... HERE I WANT FOR EACH FLAT WHAT IS RECEIPT NUMBER AND AMOUNT PAID. HER I USE VLOOKUP AND GETTING RESULTS. BUT IF THE FLAT OWNER PAYS TWICE I AM NOT GETTING SECOND TIME PAYMENT DE TILES. CAN ANYBODY HELP ME FOR THIS PROBLEM.

5 replies

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
Aug 24, 2010 at 08:15 AM
VLOOKUP would find out only the first instance. You would need a macro I would guess to get the all other instances

Could you please upload a sample EXCEL file WITH sample data, macro, formula , conditional formatting etc on some shared site like https://authentification.site , http://docs.google.com, http://wikisend.com/ , http://www.editgrid.com etc
AND post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too.


Note:
your data need not be to be real data but a good representative of how data looks like
0
Thanks for the reply and as desired by you i have uploaded sample Excel file where there are two sheets in speedy share. First sheet consist of data in second sheet data accessed from sheet one. Kindly solve my problem.
https://authentification.site/files/23955882/EXAMPLE.xls
0
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
Aug 25, 2010 at 08:43 AM
Well first question that comes to mind when I see you sheet is "so maximum number of times you can have same flat number, is 2 ?. So in Receipt, you would have a flat apprear either 0 , 1 or 2 times
0
Thanks
maximum number of times same flat no may be 5 to 8 max.

Kishore
0
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
Aug 26, 2010 at 08:27 AM
I think you would need to use a macro to do that. you process the sheet at one time or is it a running sheet by which i mean from month to month you have same two sheets and just keep on adding new rows to it as month changes
0
Sheet one will change month wise(Example: jan -10 one sheet, feb -10 second sheet .......).

Master sheet is another sheet where four columns will be for one month (Exaple: A1 column will be Flat NUMBER , B2,c2,d2, FOR Jan-10, E2,F2,G2 for Feb-10 like that.

Jan/10 Feb/10
FLAT NO R.NO DATE AMT R.NO DATE AMT
A101 4562 06/07/2010 500 - - -
A102 4592 10/07/2010 600 4713 09/08/2010 700
A103 4563 06/07/2010 600 4682 07/08/2010 700
A104 4509 05/07/2010 500 4633 05/08/2010 600
A105 4540 06/07/2010 500 4663 05/08/2010 600
A106 4607 10/07/2010 500 4709 09/08/2010 600
A107 4532 05/07/2010 500 4634 05/08/2010 600
0

Didn't find the answer you are looking for?

Ask a question
Sheet one will change month wise(Example: jan -10 one sheet, feb -10 second sheet .......).

Master sheet is another sheet where four columns will be for one month (Example: A2 to d2 columns are for Jan-10, E2 to G2 are for Feb-10 like that.


Jan-10 Feb-10
F.NO R.NO DATE AMT R.NO DATE AMT

A102 4592 10/07/2010 600 4713 09/08/2010 700
A103 4563 06/07/2010 600 4682 07/08/2010 700
A104 4509 05/07/2010 500 4633 05/08/2010 600
A105 4540 06/07/2010 500 4663 05/08/2010 600
A106 4607 10/07/2010 500 4709 09/08/2010 600
A107 4532 05/07/2010 500 4634 05/08/2010 600
0
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
Sep 1, 2010 at 06:15 PM
So you would in a way, do a batch process. I think you need a macro
0