New Forumula Issue

A

AlienBeans

This is the formula I'm working with right now...

=VLOOKUP(G4,D4:E4,2,FALSE) The value for column E goes to cell 19.
After it reaches 19, I want it to start back at E4. How do I get it to
do that?? I want column G and Column D to continue. My sheet goes to
row 120
 
B

Bob Phillips

=VLOOKUP(INDIRECT("G"&MOD(ROW()-4,15)+4),$D$4:$E$4,2,FALSE)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
B

Bob Phillips

Looking at this again, isn't your formula just

=IF(G4=D4,E4,NA())

so you can use

=IF(INDIRECT("G"&MOD(ROW()-4,15)+4)=INDIRECT("D"&MOD(ROW()-4,15)+4),
INDIRECT("E"&MOD(ROW()-4,15)+4),NA())

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
A

AlienBeans

Bob,

thanks for the help. NO, the formula I posted is the one in place. I
was there from another sheet, and I thought it might work in this case
It didn't. Now, I think I left off a piece of the puzzle. I'v
attached a copy of the sheet I'm working on so you can see it. I nee
ALL players individual cells to reference back to a specific spot. I
other words, looking at the spreadsheet, lets use Player 25 as a
example. The choices you see under player 25 in column O are going t
be referenced to the WINNERS in column D cells 4-19. In turn the PTS
column next to player 25 (column P) should pull the point totals fro
column E. Not all selections will be correct, and if they didn't pic
that field correctly, I want it to return a ZERO, so each players tota
will add at the bottom as the sheet is filled in.

So, in player 25's case. If cell O45 matches D5 then the point tota
in E5 should show up in P45. If those cells don't match, then P4
should show a ZERO(0). Does this make sense

+-------------------------------------------------------------------
|Filename: Spreadsheet.JPG
|Download: http://www.excelforum.com/attachment.php?postid=4826
+-------------------------------------------------------------------
 
Top