<div>
<div class="content wysiwyg-content">
Hi!<br />
I have the following formula that looks for values in a separate worksheet, whenever it doesn't find a value it places the #N/A symbol in the cell. Since I will be charting this information how can I get the cell to be left blank if nothing is captured ?<br />
<br />
=INDEX('Act vs Bud'!$I$2:$ES$401,MATCH($A<wbr />9,'Act vs Bud'!$A$2:$A$401,0),MATCH(<wbr />B$1,'Act vs Bud'!$I$2:$ES$2,0))
</div>
</div>


Hi!
I have the following formula that looks for values in a separate worksheet, whenever it doesn't find a value it places the #N/A symbol in the cell. Since I will be charting this information how can I get the cell to be left blank if nothing is captured ?

=INDEX('Act vs Bud'!$I$2:$ES$401,MATCH($A9,'Act vs Bud'!$A$2:$A$401,0),MATCH(B$1,'Act vs Bud'!$I$2:$ES$2,0))

Avoid #N/A in an Index Match Formula

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.