View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Minos Minos is offline
external usenet poster
 
Posts: 3
Default Error in vlookup formula

Hi,
I use the following formula on one of my spreadsheets
=VLOOKUP(C24,Input!$K$17:$R$1000,8,FALSE) but it returns a #N/A error
message. I want to change the formula that it displays a 0 (zero) instead of
#N/A. I thought of including an ISERROR statement but the formula keeps
returning the error message.

Can somebody please help?

Thanks

Minos