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 ?