• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Index match - remove the #N/A from returning

Status
Not open for further replies.
L

lwilt

Member
on excel 2010. trying to run an index match but if it can't return a value I want the field to be blank instead of coming back as #N/A.

my formula is:

=INDEX(Sheet2!$A$2:$A$17746, MATCH(Sheet1!V2,Sheet2!$B$2:$B$17746,0))

please help
 
Status
Not open for further replies.
Back
Top