Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can't figure it out
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can't figure it out
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 "bat_big " wrote in message ... 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, i want the player name to go next to the QB1 on page 5, if a 2 go next to QB2 and so on. on page 1 the are 25 possible choices...how can i make this happen? i have tried a bunch of different statements and cannot seem to make this work. --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HOW TO 'BLINK' A FIGURE INSTEAD OFF BOLDING THE FIGURE | Excel Worksheet Functions | |||
Can anyone help me figure this out???? PLEASE???!!!??? | Excel Discussion (Misc queries) | |||
Can't figure this out!!! | Excel Worksheet Functions | |||
Pg 98 - Figure 3-24 Help | Excel Discussion (Misc queries) | |||
I just can't figure this one out | Excel Discussion (Misc queries) |