Array Formula Not Filling Down Column

[seans81]

Hello,

I have an array formula that returns values based on a couple criteria, it references a couple columns in the active sheet and another sheet called "reference". The forumla works by itself, but as an array it does not fill down for some reason:

This formula Would go in column I1

=ArrayFormula(if(H:H<>"Campaign #",(iferror(Lookup($A:A,Reference!$G:G/(Reference!$B:B=$H:H),Reference!$C:C),"No Match")),"Mail Piece"))


Example Sheet 1:

A	B	C	D	E	F	G	H	I
Date							Campaign
May 15, 2020							1

Reference Sheet:

A	B	C	D	E	F	G
NUMBER	Campaign	Product				Delivery Date
1	1	Screws				May 15, 2020

So what should happen is when I insert the formula into column I of sheet 1, it should fill down the rest of the columns with the array, but it doesn't fill down.

I am using this in google sheets.

 

[seans81]

This is the current formula I am using:

={"Mail Piece";ArrayFormula(iferror(Lookup($A:$A,Reference!$G:$G/(Reference!$B:$B=$H:$H),Reference!$C:$C),"No Match"))}

It only fills down 1 row, not sure why not all of them

 

[Peter_SSs]

I am using this in google sheets.

So please don't put such questions in the Excel Questions forum in future. I have moved it this time to 'General Discussion & Other Applications' whose description includes: This is also the place to ask about other spreadsheet programs (e.g. Google Sheets)

 

[seans81]

Any help?

 

[seans81]

any help?

 

[Peter_SSs]

any help?

A couple of things are working against you.
- It is weekend so not as many potential helpers are usually about.
- Most people here are Excel users/helpers - not as many familiar with Google Sheets. There is no guarantee that anybody will offer help but it is quite possible that somebody with Google Sheets skills may come along in due course.