• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Interactive Table in Excel (Change Values based on dropdown list)

R

rush2rajen

Member
Hi Friends,

I want to make a Interactive Table in Excel 2007.
This Table should show Individual Centre & Department ( Sales & NOC's )

For e.g : If I select A from dropdown : then it should show
Sale of Apr, May, June and so on
Patients of Apr, May, June and so on
NOC of Apr, May, June and so on


Kindly help.

Thanks
Raj
 

Attachments

Misraji,

A little help required I was making the same but somehow I think I am missing something that's why figures are not coming while I am selecting the dropdown.

Please help on this and request you to kindly "BOLD" mark my mistake wherein I am doing so that from next time I don't repeat the same mistake.

Thanks in advance.

Raj
 

Attachments

Hi,

Misraji's file is absolutely correct but when I am trying the same reducing the range,
I am unable to do so. I had attached both the sheets in a workbook.

I am unable to understand where I am making the mistake.
Kindly help in correcting my mistake. And please add comment or BOLD the text where I am making a mistake.

Thanks
Raj
 

Attachments

@rush2rajen

If you see your column number argument of INDEX function, it is USING MATCH function to get column number. Now in MATCH function you are looking APR against APR SALES with exact match, that's why the formula is returing #N/A error. I would suggest you to go through the following links to get some insight on MATCH function:

http://support.microsoft.com/kb/214142

http://office.microsoft.com/en-in/excel-help/match-function-HP010062414.aspx

http://chandoo.org/wp/2008/11/19/vlookup-match-and-offset-explained-in-plain-english-spreadcheats/

Regards,
 
Hi Somu..

Just for sharing purpose.. :)

=INDEX(($A$2:$D$13,$A$16:$D$27,$A$30:$D$41),MATCH($H$8,$A$2:$A$13,0),COLUMN(B1),ROW(A1))

Index function also has a great rarely use parameter available.. :)
with the help of perfect data structure in the above case.. you can use a single formula for the same..
 

Attachments

You must log in or register to reply here.
Back
Top