I have worked through some of this and changed a few things but i need the
formula to recognize all of the short named data into the total comapany name.


=INDEX($A$1:$B$960,MATCH(D3,$B$1:$B$960,0),MATCH($ E$1,$1:$1,-1))

yes i did remove the sheets out and this works but only on an exact match

--
Message posted via http://www.officekb.com