Many many thanks to Mr. BadlySpelledBuoy. Now please advise how can I avoid "#N/A" when I put the formula to another cells (see attachment).
Many many thanks to Mr. BadlySpelledBuoy. Now please advise how can I avoid "#N/A" when I put the formula to another cells (see attachment).
You can use ISERROR(). Like
Please Login or Register to view this content.
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
Thank you, my formula is =INDEX(L$1:L$200,MATCH(C23,K$1:K$200,0)). Would you please advise me how can I put it. Sorry for botheration.
sktneer's instructions were pretty clear....
=IF(iserror(INDEX(L$1:L$200,MATCH(C23,K$1:K$200,0))),"",INDEX(L$1:L$200,MATCH(C23,K$1:K$200,0)))
Last edited by FDibbins; 03-27-2014 at 01:08 AM.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Try this.........
=IF(ISERROR(INDEX(L$1:L$200,MATCH(C23,K$1:K$200,0))),"",INDEX(L$1:L$200,MATCH(C23,K$1:K$200,0)))
Thank you both sktneer & FDibbins. You are really great!
I'll remain you,
Bablubg
Glad to help you. Thanks for the feedback.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks