Use Excel's vlookup function.
In cell D4 (where you want the 10 returned): =vlookup(b4,Sheet1!B:C,2,false)
and in E4: =vlookup(c4,Sheet1!B:C,2,false)
(You may need to change the Sheet1 reference if the name of your first
worksheet is different and/or it's in a different workbook). As you're
entering the formula, the easiest way to create the cell references will be
just to click to select columns B and C from your first worksheet.
One caveat: you'll want to use the exact same team names (ex Balt vs Balt.)
in both worksheets.


"FLKULCHAR" wrote:

> I have a list of NFL teams in column A (alphabetized) with their rating in
> column B:
>
>
> 1 COL B COL C
> 2
> 3 Balt 10
> 4 Chicago 8
> 5 Cleve 13
> 6 Dallas 17
> 7 Denver 9
> 8 Green Bay 15
>
> etc., etc.
>
> I wish to search for the entire 32 teams (columns 3 thru 34, column B) for a
> team name, then insert its rating (col. C) into a new list.
>
> For example, on another spreadsheet I have the weekly schedule.
>
> In row 4 I have:
>
> col A col B col C col D col E
> 4 Balt. Green Bay ??? ???
>
> I wish to insert the teams' rating into column D (for Balt) and column E
> (for Green Bay). [in other words, a 10 and a 15]
>
> How is this done???
>
> I believe it is some type of array look-up routine...search for the match,
> then enter the data.
>
> Please advise.
>
> FL KULCHAR
>
> please also notify flk2575@yahoo.com
>
> THANK YOU
>
>