Searching an Alphabetized list for data, then RESORT

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 [email protected]

THANK YOU

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 [email protected]
>
> THANK YOU
>
>

I keep getting a #REF error, and I do not understand why?

pls help...we are almost there

"bpeltzer" wrote:

> 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 [email protected]
> >
> > THANK YOU
> >
> >

Never Mind...your rsvp is PERFECT,,,

thank you very much...you have helped me immeasurably!

FLK

"bpeltzer" wrote:

> 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 [email protected]
> >
> > THANK YOU
> >
> >

Can you paste the formula that's generating the #REF? Also tell us what cell
the formula is in, and where your source data (the table with each team's
rating) is located -- workbook name, worksheet name and cell range.
Usually, the #REF comes about when the 'column index' in the vlookup is
greater than the number of columns in your 'table array'. Ex: if your table
array is B:C (two columns) and your column index is 3, you'd get the #REF.

"FLKULCHAR" wrote:

> I keep getting a #REF error, and I do not understand why?
>
> pls help...we are almost there
>
> "bpeltzer" wrote:
>
> > 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 [email protected]
> > >
> > > THANK YOU
> > >
> > >