Learn MS Excel – Video 371- Arrays Get Lookup values horizontally -INDIRECT OFFSET ROW LARGE



In this Video we are using INDIRECT, OFFSET, ROW .LARGE AND IFERROR IN SINGLE FORMULA.. One of the toughest tasks solved with phenomenal arrays.

-~-~~-~~~-~~-~-
Please watch: “Learn Excel – Video 594 – VBA – WEB SCRAPING – CLICK ON SEARCH BUTTON”

-~-~~-~~~-~~-~-

3 thoughts on “Learn MS Excel – Video 371- Arrays Get Lookup values horizontally -INDIRECT OFFSET ROW LARGE

  1. Great video. I had a very similar problem I was solving just last week and I finally (after forever playing with the formula references) this is what worked for me.. {=index ($A$1:$A$10),small (if($A$2:$A$10=C$2),row ($A$2:$A$10)-row($A$2:$A$2)+1),Columns(C$3:C3)))}

    I wish I would have seen this video first….. what a great job you guys do teaching!

Leave a Reply

Your email address will not be published. Required fields are marked *