Mr/Mrs Valko .............PURE GENIUS !!!!!!!!!!!!!!!!!!!!!!!!!!

THANK YOU for the quick and kind help!

I"M SAVED !!!!!!!

"T. Valko" wrote:

If your named range includes the column headers try this:

=VLOOKUP(A12,look,MATCH(B11,INDEX(look,1,),0),0)


--
Biff
Microsoft Excel MVP


"Cornelius" wrote in message
...
This did not work. My data range is as you show below with ABC being in A2
and Week2 being in C1. I then have an ABC on another tab ( cell A12)
against
which I want to do the formula.Above and to the right of A12 in this other
tab I also have Week2 (B11) So I called the data range "look" via insert
name
define .....

My formula reads as follows

=VLOOKUP(A12,look,MATCH(B11,look,0),0)

Am I doing something wrong ?

"T. Valko" wrote:

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 ?