Excel Help Index, Match, If Statements

[pdawg123]

Hi I need some help in Excel. I currently have a worksheet that I index a pivot table and match corresponding unique numbers and return totals for columns on the pivot table. Currently if a unique number does not have a matching number it will return n/a. I want it to be able to return 0.

https://spreadsheets.google.com/spr...DD_Y3dEpQVTVFN25HRWVRTVgtNnoxcTNXX2c&hl=en_US

 

[CWatts]

Using "yourformula" as the formula you have returning the #N/A, you can use:

Excel 2007+
=IFERROR(yourformula,0)

Or in Earlier Versions of Excel
=IF(ISERROR(yourformula),0,yourformula)

 

[pdawg123]

thanks! simple answer my brain just is not processing things today I suppose