Match formula

[nimerod]

Hey guys, quick Question...


I have this data base that is filtered by a drop down and a MATCH formula menu in another sheet!

The thing worked beautifuly until I added stuff in the Z, AA, AB and AC column.


Now the formula does'nt return scrap it only shows...the formula! here is my formula.


=INDEX(Data!$A$1:$AC$21,MATCH('VIEW'!$F$15,Data!$A$2:$A$21,0),MATCH(Y$1,Data!$A$1:$AC$1,0))


VIEW is my Sheet with my access menu


Thank you

 

[Debraj]

Hi Mimerod..

I hope, the formula was not applied in Data / View Sheet.. It may be in third sheet..

If so, then can you please change the formula to

=INDEX(Data!$A$1:$AC$21,MATCH('VIEW'!$F$15,Data!$A$2:$A$21,0),MATCH('VIEW'!$Y$1,Data!$A$1:$AC$1,0))


otherwise, It looks fine to me.. It not resolved.. then better to upload sample file..


Regards,

Deb

 

[nimerod]

Yes, you are right the formula is applied in a third sheet, named: "transfer".


Still doesn't work, I really don'T know what is the trouble thought. I have the same formula applied to every column and it work fine up to Y!

 

[NARAYANK991]

Hi ,


When you say the formula does not work beyond column Y , what do you mean , does it show any error value , or does it show 0 or any other wrong value ?


What do 'VIEW'!$F$15 and 'VIEW'!$Y$1 contain ?


Since the column is a problem , what do Data!$A$1:$AC$1 contain ? At least , what does Y1 contain , and what do Z1 , AA1 , AB1 and AC1 contain ?


You can place the cursor in any cell beyond column Y , where this formula is present , and click on Evaluate Formula ; step through the execution of the formula , and see at what stage you don't get what you would expect ; you can compare the execution of the formula in any cell which gives a correct result , with the execution of the formula where you don't get a correct result to decide on what the problem is.


Narayan

 

[SirJB7]

Hi, nimerod!

As Debraj Roy asked, it'd be very helpful if you upload a sample file.

Regards!