I have no idea why that would return #NAME?.

As long as the functions were spelled correctly there's no reason for it to
return #NAME?.

Got me?????????

Biff

"kgoldner" wrote in message
...

I tried this formula but the NAME error came back when entered

=INDEX($C4:$N6,MATCH($O8,$O4:$O6,0),COLUMN(A:A))


--
kgoldner
------------------------------------------------------------------------
kgoldner's Profile: http://www.hightechtalks.com/m715
View this thread: http://www.hightechtalks.com/t2331809