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.