I am trying to group/select few column in a big table , like column c , f, i, l,,,, along with the value and information in the rows.
What need is ,from the table (example) , I would like to select 1 or 2 options from the drop down list.
When I select this any of this , figures / information in the rows also should be selected along with this drop down list.
Does any one has idea?
I am not so familiar with vlookup, but I can try.
Can any one help me?
| |
|
|
|
|
|
|
|
|
|
| |
|
|
Dropdown list 1 |
April |
Dropdown list 2 |
Sales |
|
|
| |
|
|
|
May |
|
|
Income |
|
|
| |
|
|
|
June |
|
|
Expeneses |
|
|
| |
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
| Detail 1 |
Detail 2 |
Detail 3 |
Detail 4 |
Sales Apr |
Income Apr |
Expenses Apr |
Sales May |
Income May |
Expenses May |
| |
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
Thanks