CODEWITHSUNDEEP
google-sheets
xyz
xyz

Reputation: 2300

Add Filter to Vlookup formula Google sheets

I know verry little about formulas

I have a Vlookup formula which is working

=ArrayFormula(iferror(vlookup(ConnectionHelper!M2:M, ConnectionHelper!$D$2:$E, {2,1}, false)))

I want to FILTER out rows if a cell in column D is empty

But not getting how or ever if possible!

I am trying

=Filter(ArrayFormula(iferror(vlookup(ConnectionHelper!M2:M, ConnectionHelper!$D$2:$E, {2,1}, false))),D2:D<>'')

Thanks

Upvotes: 0

Views: 3626

Answers (1)

JPV
JPV

Reputation: 27262

Try

=query(ArrayFormula(iferror(vlookup(ConnectionHelper!M2:M, ConnectionHelper!$D$2:$E, {2,1}, false))), "where Col2 <>''")

(assuming your data in column D is text).

Upvotes: 1

Related Questions