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

--
Message posted from http://www.ExcelForum.com