Monday, January 22, 2018

yogi_Work Around For Using An ArrayFormula Where Filter Function Is Being Used

Google Spreadsheet   Post  #2352

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Jan-22-2018


Hi all, can anyone give me a hint with this?
I have this fórmula

=IFERROR(VLookup(TODAY(),Filter('Inventário'!$A2:$C,'Inventário'!$B2:$B=$A2),3,1),0)

I would like to make it and arrayformula, just like this:

=IFERROR(VLookup(TODAY(),Filter('Inventário'!$A2:$C,'Inventário'!$B2:$B=$A2:$A),3,1),0)

I know that FILTER doesn't work with ARRAYFORMULA, and am also aware that VLOOKUP does. My problem is that i haven't figure out a way of transforming that FILTER into and WORKING VLOOKUP.

Any help/hint would be much appreciated.