Is this a vlookup or hlookup task

D

Dafella

*Sorry if this is a double post I received an error when posting

All,
With my data looking as followed:



********Proj1****Proj2****Proj3
Jill*****5********0*********8
Scott****0********3*********0
Randy****9********4*********3
Bill*****3********0*********0


How can I lookup the value for a person depending on the col

So if my question is "How many hours did Randy charge to Project 2"

The answer should be 4.

My spreadsheet is more complicated than this but this is my hangup right now.
Because I've never had to do something like this before.

PS: Disregard the '*' that is for spacing purposes.




Thanks in advance

Steve
 
J

Jonathan Rynd

[email protected] (Dafella) wrote in

A B C D
1 ********Proj1****Proj2****Proj3
2 Jill*****5********0*********8
3 Scott****0********3*********0
4 Randy****9********4*********3
5 Bill*****3********0*********0
How can I lookup the value for a person depending on the col

So if my question is "How many hours did Randy charge to Project 2"
Click to expand...

=INDEX(B2:D5,MATCH("Randy",A2:A5,0),MATCH("Proj2",B1:D1,0))

One of the Excel MVPs has a website with many examples...let me see if I
can find it...here it is:
http://www.mvps.org/skp/xl00002.htm
 
Top