Thread: lookup returning #N/A
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default lookup returning #N/A
Try this,

=IF(OR(F21="",COUNTIF(O:O,F21)=0),"",INDEX(Densiti es!O:P,MATCH(F21,Densities!O:O,0),2))

Mike

"Miree" wrote:

i have the formula,
=IF(F21="","",INDEX(Densities!O:P,MATCH(F21,Densit ies!O:O,0),2))
This returns #N/A if the F21 string can not be found
It there anyway to get it to return 0 or empty insstead?

Reply With QuoteReply With Quote