yogi_For Entities In D7:D11 Compute Entries In Corresponding Rows Of Column I For Matching Entries In Table J4:Y11

Google Spreadsheet   Post  #2542

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

question by: Cody Marish
https://productforums.google.com/forum/?utm_medium=email&utm_source=best_answer_notification_button#!topic/docs/f4YtAhFoJRc;context-place=forum/docs

Confused on the use of LOOKUP in this formula.
I do not understand why LOOKUP in this formula behaves as it does and uses the number 2 as the search term and how it properly works with the rest of the formula.

Additionally I also do not understand why I cannot properly set up this formula as an array of answers like I would expect. Any help would be appreciated.

Link to the example document:

https://docs.google.com/spreadsheets/d/1K43UUp4QVxsAn-1uswSse766y1gm-Syq2oLJyqXS2xE/edit?usp=sharing