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


--
AlienBeans
------------------------------------------------------------------------
AlienBeans's Profile: http://www.excelforum.com/member.php...o&userid=32352
View this thread: http://www.excelforum.com/showthread...hreadid=546965

=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)

"AlienBeans" wrote
in message ...

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


--
AlienBeans
------------------------------------------------------------------------
AlienBeans's Profile:
http://www.excelforum.com/member.php...o&userid=32352
View this thread: http://www.excelforum.com/showthread...hreadid=546965

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)

"AlienBeans" wrote
in message ...

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


--
AlienBeans
------------------------------------------------------------------------
AlienBeans's Profile:
http://www.excelforum.com/member.php...o&userid=32352
View this thread: http://www.excelforum.com/showthread...hreadid=546965

Bob,

thanks for the help. NO, the formula I posted is the one in place. It
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've
attached a copy of the sheet I'm working on so you can see it. I need
ALL players individual cells to reference back to a specific spot. In
other words, looking at the spreadsheet, lets use Player 25 as an
example. The choices you see under player 25 in column O are going to
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 from
column E. Not all selections will be correct, and if they didn't pick
that field correctly, I want it to return a ZERO, so each players total
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 total
in E5 should show up in P45. If those cells don't match, then P45
should show a ZERO(0). Does this make sense?


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

--
AlienBeans
------------------------------------------------------------------------
AlienBeans's Profile: http://www.excelforum.com/member.php...o&userid=32352
View this thread: http://www.excelforum.com/showthread...hreadid=546965

still in desperate need of help with this one...thanks..


--
AlienBeans
------------------------------------------------------------------------
AlienBeans's Profile: http://www.excelforum.com/member.php...o&userid=32352
View this thread: http://www.excelforum.com/showthread...hreadid=546965