OOTP Developments Forums - View Single Post

pstrickert · 04-09-2007, 09:51 PM

I'm not too familiar with Excel, so forgive me if this is a stupid question. Does the vlookup formula have to be inserted for every record in the database? Here's what I mean . . .

If "a1" in . . .

a1,1980Stats!$a$1:$v$??,3

refers to the first record, then does "a1" have to be replaced with "a2", "a3", "a4", etc., on each successive line, in order to account for every player? Otherwise, the formula only works for the player whose name appears in "a1", right?

Thanks.

04-09-2007, 09:51 PM	#2
pstrickert Hall Of Famer Join Date: Dec 2005 Posts: 17,134	I'm not too familiar with Excel, so forgive me if this is a stupid question. Does the vlookup formula have to be inserted for every record in the database? Here's what I mean . . . If "a1" in . . . a1,1980Stats!$a$1:$v$??,3 refers to the first record, then does "a1" have to be replaced with "a2", "a3", "a4", etc., on each successive line, in order to account for every player? Otherwise, the formula only works for the player whose name appears in "a1", right? Thanks.