Sorry, I didn't word my response very well - I didn't mean for the first
formula to be used at all...
Now that you have a new column H & the "pts" column is column I, try
typing,
In H6 (this column can be hidden later):
=VLOOKUP(G6,$D$6:$E$100,2,FALSE)
and in I6:
=IF(ISNA(H6),0,H6)

Select cells H6 & I6, [ctrl + c], select as many rows down as you need
(in these columns) & press [ctrl + v].
Does this give the results you want in column I?

Re the vlookup working in some cells but not others is strange & may be
due to a quite a number of things - it's hard to know without the
spreadsheet. Reasons include cells being formatted differently (eg as
text), spelling errors (eg extra spaces - do a visual check) or
non-printing characters etc. To overcome any cell formatting problems
try selecting your data (not the headers) & clearing the formats (ie
[alt + e + a + f]).

If this doesn't work, the quickest (since it is only a small
spreadsheet) fix may be to copy the appropriate team in column D (ie
[ctrl + c]) & paste it over the top of the "matching" cell in column G
(ie [ctrl + v]). This way we can be certain that exactly the same thing
is in both cells & the lookup should/will work.

If you keep having problems can you please attach another screendump of
your spreadsheet showing the formulae & we may be able to track the
problem. To do this:
show the formulae press [ctrl + `] (the symbol is at the top left of my
keyboard, by the # 1), select all [ctrl + a], autofit columns [alt + o +
c + a], and post your screen dump.


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


AlienBeans Wrote:
Thanks for the response. This has helped but has lead to other
questions..lol.

This formula that you gave me:
=IF(ISNA(VLOOKUP(G6,$D$6:$E$100,2,FALSE)),0,VLOOKU
P(G6,$D$6:$E$100,2,FALSE)) Where do I insert this? based on my
spreadsheet?? I have added the new column H, but i find when using the
above formula it works in some cells but not in others. I can change
the first and last G cell to match where i want it to pull but i don't
always get the points value that is assigned to the referencing pts.
column. I will get ZERO regardless of who i put in the field. Any
suggestions...It seems to work on its own, but not in every
cell....very strange...


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