Hi

Use the MATCH function as well as INDEX.

=INDEX($A$1:E$6,MATCH(Name,$A$A,0),MATCH(week,($1: $1,0))

Substitute the word Name and Week with the cell references holding the
Company and Week Number or insert their text as "Company2" and "Week 44"
for example.

--
Regards

Roger Govier


"Olle" wrote in message
...
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%