Is this a vlookup or hlookup task

[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

 

[Jonathan Rynd]

(e-mail address removed) (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"

=INDEX(B25,MATCH("Randy",A2:A5,0),MATCH("Proj2",B11,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