Try this:

...........A..........B.............C............. .D.....
1................Week1.....Week2.....Week3
2....ABC.......20............30.............40
3....DEF........10............20............30

I would like to be able to look for ABC in week2

A10 = ABC
A11 = Week2

=VLOOKUP(A10,A1:D3,MATCH(A11,A1:D1,0),0)


--
Biff
Microsoft Excel MVP


"Cornelius" wrote in message
...
I am trying to lookup data that is in a named range across columns and
rows:

Rough idea as follows : Week1 Week 2 Week 3
ABC 20 30 40
DEF 10 20 30

I would like to be able to look for ABC in week2 , no matter in what
column
number on the spreadsheet it may appear. The column will allways have the
heading Week2. Is there a way to combine the Vlookup and or Hlookup
functions
so that I can find ABC Week2 as long as it appears in the named range but
without having to specify what column number it will be in ?