Larry,

=INDEX(OFFSET(INDEX(Database!A:A,MATCH(F7,Database !A:A,FALSE)),0,0,1,256),MA
TCH("CWS",OFFSET(INDEX(Database!A:A,MATCH(F7,Datab ase!A:A,FALSE)),0,0,1,256)
)+1)

All on one line.

HTH,
Bernie
MS Excel MVP


"Larry" wrote in message
...
I want to look down a column until I find a value eg. 10/May/05
I want to look across that row until I find a value eg. "CWS" and then
return
the value of the cell one to the right of the cell containing "CWS".
I tried to use a use a lookup formula containing a match formula to find
the
column
but the match formula requires a specified range. In my cenario my range
varies
depending upon the date selected. This range needs to be specific to one
row but change depending upon the row selected.
Here is the formula I came up with but doesn't work because the range in
the
match section is rigid.
=(VLOOKUP(F7,Database!$A:$AQ,
(MATCH("CWS",Database!A6:AQ6,0))+1,FALSE))
The range to look in always covers the same columns but only covers one
row
and that row is specific to the date looked up.
any Ideas