Hi
I usually use this formula on vertical matches but I need something similar to
work with horizontal match then check col 2
I need something like this
=INDEX('2SCHUL'!$BV4:$CH4,MATCH($J11,'2SCHUL'!$BV4:$CH4,0),2)
Or another idea would be. How can I copy
and paste the results form Horizontal to Vertical and have the results
change as the other cells change.
Dont really want to do it manually (too big)
Any Ideas I can play with Thanks Johny
I usually use this formula on vertical matches but I need something similar to
work with horizontal match then check col 2
I need something like this
=INDEX('2SCHUL'!$BV4:$CH4,MATCH($J11,'2SCHUL'!$BV4:$CH4,0),2)
Or another idea would be. How can I copy
and paste the results form Horizontal to Vertical and have the results
change as the other cells change.
Dont really want to do it manually (too big)
Any Ideas I can play with Thanks Johny