View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Susana C via OfficeKB.com Susana C via OfficeKB.com is offline
external usenet poster
 
Posts: 7
Default #N/A Replacement

I searched a the "Correct #N/A Error" threads and found some info on isna and
iserror, but I must be doing something wrong. For any item that is not found
in the following lookup, I would like the "COR" to be returned. How do I do
this? I am using the ,0 at the end in liu of "false" because "false" does
not work when you have multiple active filters working.

=VLOOKUP($D19,'[Fee File.xls]Fees'!$C$13:$H$20108,1,0)

Thank you!

--
Message posted via http://www.officekb.com