Hello Friends,
Please refer attached spreadsheet which clearly explains the problem. I am not sure where the error is in the formula. Also I would like to add one more condition to it.
Another problem- I created Drop Down using Data Validation. Now I need to make the Drop DOWN ICon visible. It becomes visible only when I click on the cell.
THanks
Dumbo
=index($b4:$m4,,match($q$3,$b3:$m3,0))
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Try this for the formula.Formula:
Please Login or Register to view this content.
As for the dropdown being visible without entering the cell, that's not possible with a data validation dropdown.
If posting code please use code tags, see here.
Thank you very much
How will I add another match to this formula, that is to match cell Q3, right now it is matching only cell value in Q2
If not data validation, then is there any other way I can make it visible ?
I believe there will be only one match and the result will be Number alone. Then try SumIfS() like this...
=SUMIFS($B4:$M4,$B3:$M3,$Q$3,$B2:$M2,$Q$2)
thank you very much Six Sense
Check Form Combobox option from developer tab. But it is going to be a round way approachOriginally Posted by Excel Dumbo
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks