VLOOKUP
Closed
KISHORE
-
Aug 21, 2010 at 08:30 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Sep 1, 2010 at 06:15 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Sep 1, 2010 at 06:15 PM
5 responses
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Aug 24, 2010 at 08:15 AM
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
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
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
https://authentification.site/files/23955882/EXAMPLE.xls
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Aug 25, 2010 at 08:43 AM
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
Thanks
maximum number of times same flat no may be 5 to 8 max.
Kishore
maximum number of times same flat no may be 5 to 8 max.
Kishore
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Aug 26, 2010 at 08:27 AM
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
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
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
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
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
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Sep 1, 2010 at 06:15 PM
Sep 1, 2010 at 06:15 PM
So you would in a way, do a batch process. I think you need a macro
