vlookup error

  • Thread starter Thread starter ANTiSEEN
  • Start date Start date
A

ANTiSEEN

How can I make the vlookup function not return anything if it can't find the
reference data in the far left column? If it can't find the lookup data can
it just return nothing?

I am trying to make my totals worksheet look in a column for initials, then
return the value from a cell in the same row where the initials are entered.
I can get it to return the value if the lookup column has the initials, but
if the initials it's looking for aren't in the first column it returns #N/A
and then it won't add. Is there a way to sum a range of cells and get it to
ignore the #NA and just add the cells with numbers?
 
Where do I put that, in the vlookup or the sum? here's the formula.....

=VLOOKUP("crs",Saturday!C7:Q26,11)
 
=IF(ISNA(VLOOKUP("crs",Saturday!C7:Q26,11)),"",VLOOKUP("crs",Saturday!C7:Q26
,11))

Only personally I would add the FALSE condition, like

=IF(ISNA(VLOOKUP("crs",Saturday!C7:Q26,11,FALSE)),"",VLOOKUP("crs",Saturday!
C7:Q26,11,FALSE))
This will force the formula to return only exact matches..........

And you might want to consider makeing the lookup ranges ABSOLUTE, as
=IF(ISNA(VLOOKUP("crs",Saturday!$C$7:$Q$26,11,FALSE)),"",VLOOKUP("crs",Satur
day!$C$7:$Q$26,11,FALSE))


Vaya con Dios,
Chuck, CABGx3
 
Back
Top