Re: Vlookup combined with Hlookup

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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" <Cornelius@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:23DE0866-F344-4E31-BA18-B47B97983BE0@xxxxxxxxxxxxxxxx
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 spread*** 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 ?





.

Quantcast