Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
What cellformula, using column and row names, return a specific value from a
table like below? (I cant use the INDEX function since I dont know the column or row numbers in the actual table, only the names) A B C D F 1 Week 42 Week 43 Week 44 Week 45 2 Company 1 67% 71% 69% 81% 3 Company 2 45% 78% 79% 73% 4 Company 3 88% 67% 86% 74% 5 Company 4 97% 56% 77% 92% 6 Company 5 87% 55% 82% 69% |