Index match formula unable to arrive a formula

Hi

Please find excel template

I need to extract values using index match both rows and colums

ist sheet is having the master data
2nd sheet i would like to extract the data o by using index and match
I indent to use for extracting for bringing non blank and non zero values to extract of dues dates of payment due dates schdule of parties
The formula given in 2nd sheet is not working
I am trying to use match and index instead of vlookp since it will handle multiple values

Please help.
Thanks & Regards
N.Srinivasan

Hi
thanks for your help.

I am trying toextract values of sheet1 to sheet2

vlook bring only first value and not mutiple values
I understand index match will bring multiple values

If dates are spread around year 01/01/2015 to 31/03/2016
I would like the formula to pick up only for dates where value is available
can you please help.
Thanks

Hi
Many thanks
It is working However formula does not work if the addtional rows are added though I have altered range.
please find template.

Any help for bringing out only cell values wheich are non zero or non blank cell alone.

Hi
Hi
This formula is working fine Thanks a lot
can you suggest a formula for bringing only values which are having non zero and non blank cell alone by combining if and match and index

Thanks

Hi Logesh

Thanks for your input.
can you suggest a formula if am deleting name of the cell in formula in name manager.

This excel file i am going to give for using to the normal user level.
I am yet to enhance their knowledge in using pivot table
That is why i am looking for a formula for using combination of if and match for bringing values only for non zero and non blank cells

Once again thanking you for your help.
Thanks

Hi
Please find my requirement Attached Please find the file
i request a formula for this.
By using vlookup or match formula I would like bring thedate colum and Amount and outpuut arrranged in rowwise



Thanks

Hi
Definitely you are helping me to a greater extent.
it is working fine
Please find template attached again.
A101 DATE 02/04/2015 showing zero value.
Is there any formula not to bring this zero values
is there any formula for bringing both date column and amount colum whereever values are available

if i am having date 01/01/2015 to 30/01/2015
This will formula will bring zero value also for everything.
However I request only date and amount to be brought only for the cell having the values

Thank u very much.

Hi Logesh
Sorry I am troubling you too much
Master sheet client code like a101,a102 are appearing
In the second sheet I would like to bring A101 date and value only for whrere (date) where amount are appearing

A101 01/01/2015 5000
15/01/2015 0
01/02/2015 5000
01/03/2015 500
The above data will be appearing in vertical(collumnar form in the maste file)
I would like to bring the value in rows one below another like this
01/01/2015 5000
15/01/2015 should not appear
01/02/2015 5000
01/03/2015 500

If you could give contact no I shall contact you My phone no.9884566159(chennai)

Thanks

Hi
Thank u very much
Sorry to trouble you.
I need a formula to look up for the code a101 only for the date column which are having the amount.if a particular is zero or blank for a particular date It should not appear

Please find the excel template

the formula shall bring both date and amount only for the amount >0 or nor blank cell