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


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


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.

No comments:

Post a Comment