remove #n/a from the columnI've used a function

S

Sue

I have used a function and dont want to get #n/a but replace with a blank
after using
=INDEX('K1'!A:B, MATCH(HAM!C62, 'K1'!A:A,0),2)
 
P

Pete_UK

You can do it like this:

=IF(ISNA(MATCH(HAM!C62,'K1'!A:A,0)),"",INDEX('K1'!A:B,MATCH(HAM!
C62,'K1'!A:A,0),2))

Hope this helps.

Pete
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Index / Match Formula Problem 4
nesting more than 7 functions? 11
Using SUMPRODUCT to find weighted averages 0
Word 2007 flash screen upside down and Word2007 cannot be used 0
Lookup Function Help 1
Deletion Of Cells 1
index and match, then subtract, divide and add for my final answer 3
Match issue 3

Top