What you have to do is match the project number against the list of
projects, and get its row number

MATCH(A3,Sheet2!$A:$A,0)

and use this row number in a lookup into the resulting values, using INDEX

INDEX(Sheet2!$H:$H,MATCH(A3,Sheet2!$A:$A,0))

and because it may not match at all, you need to check that match returns a
number

=IF(ISNUMBER(MATCH(A3,Sheet2!$A:$A,0)),INDEX(Sheet 2!$H:$H,MATCH(A3,Sheet2!$A:$A,0)),"")

--
__________________________________
HTH

Bob

"scott" wrote in message
...
I'm starting to get confused by the vocabulary in Excel. I'm not
necessarily
looking for someone to just give me a solution to my problem. I'd just
like
some advice on which functions I should be reading up on. I'm still a
newbie
to the formulas. If Excel would let me, the closest I could express what
I'm
trying to do is something like this. =IF(A3=sheet2!A$:A$, sheet2!H$:H$

Of course this doesn't work b/c I don't know what I'm doing. I know this
is
simple to some of you gurus out there, everybody starts somewhere.

To explain what I'm trying to do
A3 = a single project number
sheet2!A$:A$ = col of all project numbers on sheet2
sheet2!H$:H$ = the resulting value where A3=A$:A$ (project manager phone#)

Anyone care to point me in the right direction ..... please !

Thanks in advance for any help you can offer.