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

https://productforums.google.com/forum/#!topic/docs/EG_7crFT6q8;context-place=forum/docs

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.