I am terrible at INDEX Match multiple match
Any one help with attached
Dashboard is where it is needed - to Data.
Thanks for any help
I am terrible at INDEX Match multiple match
Any one help with attached
Dashboard is where it is needed - to Data.
Thanks for any help
Rather than having members searching around for what you want, where you want it, and what to base it on, you need to give FAR more details to us please.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Solved with concatenation on two cells
Array formula
{=IFERROR(INDEX(Grid!$D$2:$L$16,MATCH($E$15&F$16,Grid!$B$2:$B$16&Grid!$C$2:$C$16,0),
MATCH(Dash!$E17,Grid!$D$1:$L$1,0)),"")}
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks