Fetch data based on two variables from tabule

[pavanbhoyar]

Hello,
Seeking solution to fetch data from table based on two different variables.
Attached is excel sheet for reference.

Thanks and Best Regard,
Pavan

[JohnTopley]

Changed "All" to "Total" in drop-down

In B12

=INDEX($B$3:$S$6,MATCH($A12,$A$3:$A$6,0),MATCH($C$10,TEXT($B$1:$S$1,"mmmm"),0)+(MATCH($B$10,$B$2:$G$2,0)-1))

Enter with Ctrl+Shift+Enter

Copy down

BUT better (non-array)

in D12 (example)

=INDEX($B$3:$S$6,MATCH($A12,$A$3:$A$6,0),MATCH($D$10,$B$1:$S$1,0)+(MATCH($B$10,$B$2:$G$2,0)-1))

where your dates are drop down with proper Excel dates formatted as "mmmm"

You can format the "Dates" named range as "mmmm" and they will appear in the drop down as "January","February" etc.

See attached : results

[tamthat]

Hello,
Seeking solution to fetch data from table based on two different variables.
Attached is excel sheet for reference.

Thanks and Best Regard,
Pavan

Please Login or Register  to view this content.

[pavanbhoyar]

Thank you Mr JohnTopley & Mr Tamthat.
It worked for me.

Thanks.
Added reputation.

[JohnTopley]

Thank you for feedback and rep.