Hi,
This is the formula I use =VLOOKUP(A3;'[Testbook.xlsm]Sheet1'!$C:$BW;MATCH($J$2;'[Testbook.xlsm]Sheet1'!$C$2:$BW$2;0);0)
So I use the formula to copy data from a pivot table in another workbook if I have matches on A3 and J2. This is working great with one exception. I have roughly 30 columns containing this formula and under that 1000's of rows. What the formula does is look for a match on value from A3 and use the number from cell J2 to target a specific cell. The problem is that sometimes the value from J2 isn't in the pivot table and instead of returning 0 it returns N/A. How can I fix the formula to return 0 if the match value isn't there?
There is no difference if I change J2 to the specific value (I don't want to do this, I want the workbook to be easy to use if I need to switch out target data in row 2)
Thanks in advance
/René
Bookmarks