vlookup AND hlookup in one formula???

[nortron]

Hello All,

Okay, here's my question... One one work sheet I have dates across the top, and names across the left, with data for each name under each date...

Then I have another sheet where I want to pull specific data for a specific date, for a specific name.... So I would want to pull for name A, the data under August 5th... and so on... The only thing I could think of would be to combine vlookup and hlookup...Vlookup to get the name, hlookup to get the date....

Any ideas?

Thanks!

 

[Aladin Akyurek]

=INDEX(DataRange,MATCH(Name,NameRange,0),MATCH(Date,DateRange,0))

 

[Smitty]

Yup, you can use a combination of INDEX/MATCH:

Book1
	A	B	C	D	E	F
1	Date	08/01/06	08/02/06	08/03/06	08/04/06	08/05/06
2	Smitty	1	2	3	4	5
3	Bob	6	7	8	9	10
4	Greg	11	12	13	14	15
5
6	Bob	9
7	08/04/06
Sheet1

Hope that helps,

Smitty

 

[just_jon]

=INDEX($A$1:$J$10,MATCH(X1,$A$1:$A$10,0),MATCH(X2,$A$1:$J$1,0))

Or

=VLOOKUP(X1,$A$1:$J$10,MATCH(X2,$A$1:$J$1,0),0)

Where X1 holds a name and X2 holds a date.