=INDEX(‘WRP WK1’.$O$14:$O$312,MATCH(A16&C16,‘WRP WK1’.$B$14:$B$313&‘WRP WK1’.$A$14:$A$313,0))
how do I fix this function to not show #n/a and to leave a blank with there is no value
thank you in advance for any help provided
Use the IFNA function.
Example:-
=IFNA(INDEX('WRP WK1'.$O$14:$O$312,MATCH(A16&C16,'WRP WK1'.$B$14:$B$313&'WRP WK1'.$A$14:$A$313,0)),"")PERFECT ! THANK YOU MARK