Thread: MATCH FORMULA WORKS, BUT NEED HAVE BLANK CELL WHER I NOW HAVE #N/A
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Stewcrew Stewcrew is offline
external usenet poster
  
Posts: 8
Default MATCH FORMULA WORKS, BUT NEED HAVE BLANK CELL WHER I NOW HAVE #N/A
I AM LOOKING FOR A WAY TO USE THE FORMULA BELOW TO RETURN A BLANK CELL
INSTEAD OF #N/A WHERE NO MATCH IS FOUND. ANY IDEAS??

=INDIRECT(ADDRESS(ROW(CODES)+MATCH(MASTER,SECONDAR Y,0)-1,COLUMN(CODES)))

THIS FORMULA DOES WHAT IT SUPPOSED TO DO EXCEPT WHERE NO MATCH IS FOUND.

THANKS,

JIM





Reply With QuoteReply With Quote