Array arguments to ifs are of different size

2
votes

I am getting at error that 'Array arguments to ifs are of different size',and this errors shows up after 1000 rows. I need this formula to autofill, so it is added in the top row. Using VLOOKUP to match two sheets data and only display value from 'Conv' sheet only if column J contains "Demo Request". The number of rows in sheets in different, so I am not sure how to make it work.

Here's the formula:

=ARRAYFORMULA(IF(row(J:J)=1,"Demo Request",IF(ISBLANK(I:I),"",IFERROR(IF('Conv'!F:F="Demo Request",VLOOKUP(I:I,'Conv'!A:G,7,FALSE),0),0))))

Any workaround for this?

1
arraysgoogle-sheetsgoogle-sheets-formulaarray-formulasgs-vlookup
pls share a copy of your sheet – player0

1 Answers

1
votes

try this:

={"Demo Request"; ARRAYFORMULA(IF(I2:I="",,
 IFERROR(VLOOKUP(I2:I, {FILTER('Ads Conv'!A:G, 
 TRIM('Ads Conv'!F:F)="Demo Request")}, 7, 0), 0)))}

0