Thread: add If to formula to blank #n/a
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Diddy Diddy is offline
external usenet poster
  
Posts: 155
Default add If to formula to blank #n/a
Hi everyone,

I'm using the following formula

=INDEX(Stats!$K$2:$K$47,MATCH($B3,Stats!$G$2:$G$47 ,0))

How do I add to this to not have #N/A when it doesn't find a match?

Thank you!
--
Deirdre
Reply With QuoteReply With Quote