Hi,

re duplication of the vlookup formula:
DaddyLongLegs' suggestion of using dollar signs seems to be what you
need. Using dollar signs makes a reference "absolute" rather than
"relative" ie it doesn't change - check out Excel Help for more detail
[F1].

To overcome the "#N/A" problem after widening column H and half the
number of times a vlookup is performed since you have more spreadsheets
to copy your formula into I would change DaddyLongLegs sugestion of (as
per your layout):
=IF(ISNA(VLOOKUP(G6,$D$6:$E$100,2,FALSE)),0,VLOOKU P(G6,$D$6:$E$100,2,FALSE))
from above by inserting another column before column H entering
=VLOOKUP(G6,$D$6:$E$100,2,FALSE)
into the new column H (this can column can be hidden later). Then enter

=IF(ISNA(H6),0,H6)
into the "Pts" column (ie the old column H, now column I).

"There has to be a shortcut for this..."
Yes, there is, repeat the column insertion to the left of each set of
lookups.
With the references for the lookup range now being "locked" to columns
D & E, you should be able to select the 2 cells H6 & I6, copy them,
paste them down the rows needed & the same in the new columns across
the page.
Now the new columns can be hidden.


hth
Rob Brockett
NZ
Always learning & the best way to learn is to experience...


--
broro183
------------------------------------------------------------------------
broro183's Profile: http://www.excelforum.com/member.php...o&userid=30068
View this thread: http://www.excelforum.com/showthread...hreadid=543500