I can do one Index Match for one company but I am not sure how to look for the company name in the column B then index/match the table next to it.
See Attached File.
I can do one Index Match for one company but I am not sure how to look for the company name in the column B then index/match the table next to it.
See Attached File.
Put on P4
=IFERROR(INDEX($E$3:$H$14,MATCH(1,(LOOKUP(ROW($B$3:$B$14),ROW($B$3:$B$14)/($B$3:$B$14<>""),$B$3:$B$14)=$O4)*($D$3:$D$14=P$3),0),MATCH($O$2,$E$2:$H$2,0)),"")
and press all together CTRL+SHIFT+ENTER button, after that copied down and cross
hope this works
Or this regular formula...
=INDEX($E$3:$H$14,MATCH($O4,$B$3:$B$14,0)+MATCH(P$3,$D$3:$D$5,0)-1,MATCH($O$2,$E$2:$H$2,0))
copied down and across
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks