vlookup and hlookup ? required

[scottwilsonx]

Hi all, I would be very impressed if someone can help with thi
quandry:

I have a list of values, from range: AG73 to BD104. Each row has
title in column AF (showing a name), and each Column has a title in ro
72 (showing the month)

What I want to do is call a cell in sheet "kpi" based on the title i
column AF and the title in row 72.

So that for example: in sheet "kpi", I want to call month June and
name: Smith, I would be taking the information from row:Smith wher
the column title was June.


Is this possible using a vlookup / hlookup combination.
All help greatfully received.
Thanks
Scot

 

[JulieD]

Hi Scott

i would use a combination of the OFFSET and MATCH functions
assuming your list of values is in Sheet3
=OFFSET(Sheet3!AF72,MATCH(kpi!A14,Sheet3!AF73:AF104,0),MATCH(kpi!A15,Sheet3!
AG72:BD72,0))

where kpi!A14 contains the column information you are looking for and
kpi!A15 contains the row.

Hope this helps
Cheers
JulieD

 

[Bernie Deitrick]

Scott,

With "June" in A1, and "Smith" in A2:
=INDEX($AG$72:$BD$104,MATCH(A1,$AG72:$BD72,FALSE),MATCH(A2,$AG72:$AG104,FALS
E))

HTH,
Bernie
MS Excel MVP