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

THANK YOU