Add to existing match index formula a formula that will leave cells blank

I am using a match index formula to bring over data from the worksheet titled "920" to the "Data" worksheet. Unfortunately, I am unable attach the sample file I created.

This is the formula that I am using in columns D, E, F and G: =IF(ISNA(MATCH(B2,'920'!$D:$D,0)),0,INDEX('920'!$J:$J,MATCH(B2,'920'!$D:$D,0)))

Column D has names in it, and the value that it is returning from the 920 worksheet is a "0" and I would like to have it be blank

Columns E, F and G are dates formatted as dates in both the 920 (source) worksheet and in the Data worksheet where the results appear. When there are dates in the source cells, they show properly, but when there aren't dates in the source spreadsheet, the cells show "1/0/00"

I don't know where to add the leave blank formula portion, because I have tried numerous variations.

Thanks!

Unable, or unwilling to attach it??


Unfortunately the attachment icon doesn't work at the moment. So, to attach an Excel file you have to do the following: Just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

Is this it???


=IF(ISNA(MATCH(B2,'920'!$D:$D,0)),"",INDEX('920'!$J:$J,MATCH(B2,'920'!$D:$D,0)))

On second thoughts, your formula looks cumbersome in the extreme:

=INDEX('920'!$J:$J,MATCH(B2,'920'!$D:$D,0))&""

It's also generally a good idea NOT to use whole column references. Replace with a realistic range, unless you do have 1 million plus rows.

Yep. the formula at ~5:

=INDEX('920'!$C:$C,MATCH(B2,'920'!$D:$D,0))&""

does what you need.

And for the columns that return numbers, use this variant:

=IFERROR(1/(1/INDEX('920'!J:$J,MATCH(B2,'920'!$D:$D,0))),"")

You're welcome.

---

If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.

It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.