LinkBack URL
About LinkBacks
if the value = 0 its appearing #N/A how can I appear zero there or If not found show zero
if the value = 0 its appearing #N/A how can I appear zero there or If not found show zero
Wrap your formula in IFERROR...
=IFERROR(INDEX(Sal_data!$F$5:$F$5000,MATCH(1,INDEX((Sal_data!$B$5:$B$5000=C6)*(Sal_data!$A$5:$A$5000<=F5),0),0)),0)
Please update your profile as necessary to properly reflect the exact version(s) of Excel your question relates to. Members tailor answers based on your Excel version. Your profile says 2003, but your file indicates at least 2007
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks