Hello, I need help figuring out how to index and match the values in the table at the bottom of the spreadsheet with column a and column b with row 2 and return the value at the intersection into the green shaded cells. I've tried everythign I know. Thanks,
Will this formula work? Enter into cell G29 as an array with CTRL+SHIFT+ENTER and drag down.
Hope this helps!
Please Login or Register to view this content.
Spread the love, add to the Rep
"None of us are as smart as all of us."
This worked perfectly. You are awsome. Thanks
Try this
=SUMPRODUCT(($A$3:$A$26=$A29)*($B$3:$B$26=$B29)*($F$2:$AB$2=$C29)*($F$3:$AB$26))
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks