F
FLKULCHAR
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 (e-mail address removed)
THANK YOU
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 (e-mail address removed)
THANK YOU