Hi,
I have this sample data (attached)
I want to pull 364 based on the critera Data 2, b, and week 2.
I can pull 2 of the criteria using index(match,match), but I can't figure out how to do all 3. I tried index(match,match(a&b,a:a&b:b) but that didn't work either.
There shouldn't be any repeats/multiple numbers coming up using the lookup, so I'm not worried about that.
Any advice?
Thanks so much!
There is no file attached. Follow the instructions given in the yellow banner at the top of the screen.
Pete
EDIT: Ah, I see you have added it now.
Pete
try this array formula. When inputting formula make sure to use CTRL+SHIFT+ENTER. If done so correctly then { } will be added around your formula.
=INDEX($C$10:$J$21,MATCH($B$11&$C$11,$B$10:$B$21&$C$10:$C$21,0),MATCH(2,C3:$J$3,0))
change references as necessary.
<----- If you are happy with your solution please click on the "* Add Reputation" as a way to say thank you.
L11=sumifs(index($e$10:$i$20,,match(f3,$e$3:$i$3,0)),b10:b20,b11,c10:c20,c11)
Perfect, thank you everyone so much!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks