Can't figure it out

[bat_big]

i have an excel workbook and page 1 has this sort of info


1 Culpepper, Daunte MIN 4_
2 Manning, Peyton IND 6_
3 McNabb, Donovan PHI 5_
4 Hasselbeck, Matt SEA 4_
5 McNair, Steve TEN 9_
6 Green, Trent KCC 5_
7 Vick, Michael ATL 9_


there is a column between #1 and the player name.

on page 5 i have this info

QB1
QB2
QB3



if in the blank column i put a 1 next to a player name on page 1,
want the player name to go next to the QB1 on page 5, if a 2 go next t
QB2 and so on. on page 1 the are 25 possible choices...how can i mak
this happen? i have tried a bunch of different statements and canno
seem to make this work

 

[Bob Kilmer]

You might use a VLookup formula, as in "vertical look up". These are shown
on the same sheet as the source range. I often prototype stuff on the same
sheet then move it to another sheet after I get the basics right.

QB1, =VLOOKUP(1,$B$23:$C$29,2,FALSE)
QB2, =VLOOKUP(2,$B$23:$C$29,2,FALSE)
QB3, =VLOOKUP(3,$B$23:$C$29,2,FALSE)

This is what they look like on another sheet, refering back to sheet1. You
can just create the formula on the 2nd sheet, then go to the source sheet to
select the lookup range (the second parameter). Make sure range reference is
absolute (has $'s all around). The first arg is what to look for, the third
is which column to return on a match, and the False means use exact match
(not closest match).

=VLOOKUP(1,Sheet1!$B$23:$C$29,2,FALSE)
=VLOOKUP(2,Sheet1!$B$23:$C$29,2,FALSE)
=VLOOKUP(3,Sheet1!$B$23:$C$29,2,FALSE)

This formula will show #N/A until you enter a number beside the names. That
can be addressed too, if that botehrs you.

Bob