Hello,
I have been using the INDEX/MATCH function successfully in Excel. Unfortunately, when a cell has no value, it presents a "#N/A"; which doesn't look too good. I am using the following syntax:
=INDEX(Sheet2!A2:E453,MATCH(A6,Sheet2!A2:A453,0),2)
Can someone plase advise how to remove or stop the "#N/A" from displaying?. Many thanks.
Regards,
Joe
I have been using the INDEX/MATCH function successfully in Excel. Unfortunately, when a cell has no value, it presents a "#N/A"; which doesn't look too good. I am using the following syntax:
=INDEX(Sheet2!A2:E453,MATCH(A6,Sheet2!A2:A453,0),2)
Can someone plase advise how to remove or stop the "#N/A" from displaying?. Many thanks.
Regards,
Joe