VLOOKUP problem

  • Thread starter Thread starter RyneFan
  • Start date Start date
R

RyneFan

I'm using a VLOOKUP formula to find an amount of money won from the weekend's
golf tournament. VLOOKUP(Weekly!$A$3:$A$199,'2004 Results'!$D$3:$Z$151,5,FALSE)
I get the results I'm looking for but here's my problem. If the golfer didn't
make the money list for the weekend the formula returns a "#N/A". When I try to
add up an owners total winnings for the week I get the same "#N/A" message,
even when there are money amounts in some of the other cells. How can I sum a
column of numbers that would ignore the "#N/A" result?

Thanks

GinGin
 
Don't, suppress the #N/A.

=IF(ISNA(VLOOKUP(Weekly!$A$3:$A$199,'2004
Results'!$D$3:$Z$151,5,FALSE)),0,VLOOKUP(Weekly!$A$3:$A$199,'2004
Results'!$D$3:$Z$151,5,FALSE))

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
I had the same problem with a average formula. I nested it in a IF THEN
formula. =IF(ISERR(AVERAGE(C4:AZ4))," ",AVERAGE(C4:AZ4)). If the average
formula gave any type of error, the field was just blank.
 
Back
Top