I have a names in cells C2:C45 in a tab called spread. I have another tab
called pitchers with a lot more names in cells B3:B1000. I have ERA's
associated with each pitcher in cells O3:O1000. I want cell D2 in the spread
tab to find the find the pitcher listed in cell C2 (spread tab) within the
cells B3:B1000 and enter his ERA (cell O3:O1000) in cell D2. I believe I use
the vlookup but I can't get it to work. Thanks

in D2

=VLOOKUP(C2,pitchers!B3:O1000,14,False)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Jambruins" wrote in message
...
I have a names in cells C2:C45 in a tab called spread. I have another tab
called pitchers with a lot more names in cells B3:B1000. I have ERA's
associated with each pitcher in cells O3:O1000. I want cell D2 in the
spread
tab to find the find the pitcher listed in cell C2 (spread tab) within the
cells B3:B1000 and enter his ERA (cell O3:O1000) in cell D2. I believe I
use
the vlookup but I can't get it to work. Thanks

thank you

"Bob Phillips" wrote:

in D2

=VLOOKUP(C2,pitchers!B3:O1000,14,False)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Jambruins" wrote in message
...
I have a names in cells C2:C45 in a tab called spread. I have another tab
called pitchers with a lot more names in cells B3:B1000. I have ERA's
associated with each pitcher in cells O3:O1000. I want cell D2 in the
spread
tab to find the find the pitcher listed in cell C2 (spread tab) within the
cells B3:B1000 and enter his ERA (cell O3:O1000) in cell D2. I believe I
use
the vlookup but I can't get it to work. Thanks