You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
Looking up value with 2 name match + row or column number.
- Thread starter bilegt
- Start date
Hi,
in C15 to be copied across
=INDEX($C$5:$N$8,ROWS($1:1),MATCH($B$12,$C$4,$N$4,0)+COLUMNS($A:A)-1)
Hope it could be of some help
Not working. But I did this and worked. LOL. on C15:
=INDEX(C$5:N$8,MATCH($B15,$B$5:$B$8,0),MATCH($B$12,$C$4:$N$4,0))
I am having new issue now. How do you add the value of same name from another sheet? I can do +Sumproduct on that sheet. But I need to be do it "cross" sheet. I hope you understand me. Attaching example sheet. See sheet 1 and 2 from Help 2.xlsx
THANKS~!!!
Attachments
Not working. But I did this and worked. LOL. on C15:
=INDEX(C$5:N$8,MATCH($B15,$B$5:$B$8,0),MATCH($B$12,$C$4:$N$4,0))
I am having new issue now. How do you add the value of same name from another sheets (Like collecting SUM values from other sheets)? I can do +Sumproduct on each sheet. But I need to do the SUM on only 1 sheet. I hope you understand me. Attaching example sheet. See sheet1, 2, 3 from Help 2.xlsx
THANKS~!!!
Here is a better attachment. Reattaching Help 2.xlsx
Attachments
Canapone
New member
Hi again
in the second attachment I'm using a SUMIF(INDIRECT , I do not know if it can work on yor file. Maybe you could search for other approaches, searching on Google for istance "sumif across the sheets" or "sumif 3d"
In the first file I've just copied across (yellow formulas)
=INDEX($C$5:$N$8,ROWS($1:1),MATCH($B$12,$C$4,$N$4,0)+COLUMNS($A:A)-1)
Maybe I have not understand your need...
Regards
in the second attachment I'm using a SUMIF(INDIRECT , I do not know if it can work on yor file. Maybe you could search for other approaches, searching on Google for istance "sumif across the sheets" or "sumif 3d"
In the first file I've just copied across (yellow formulas)
=INDEX($C$5:$N$8,ROWS($1:1),MATCH($B$12,$C$4,$N$4,0)+COLUMNS($A:A)-1)
Maybe I have not understand your need...
Regards