yogi_Pull Data In Sheet2 From Sheet1 For Multiple Rows And Multiple Columns Using A Single VLOOKUP Formula

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #703   Aug 17, 2012     www.energyefficientbuild.com.

user meph2u said: (http://productforums.google.com/forum/?zx=jxj6uj6xudu4#!category-topic/docs/spreadsheets/1yaTPtQss_M%5B1-25%5D)
Hlookup (seemingly erroneously) returning "#N/A". What am I doing wrong?
https://docs.google.com/spreadsheet/ccc?key=0Atrb4wVf_dsSdHYxMW5WS0taUE5velZ5cHJGZ3REVXcThe list of names being used to do the look up were copied from the original.   I can't find why certain names in sheet2 columns E and F are successful, and why others return  "#N/A".
Any ideas on how I can fix this?
(Sheet1 has been provided as values to simplify the problem.   However, it will be populated with an HTMLlookup function.)
(Working on Vista/Chrome)
-------------------------------------------------------------------------------------------
following is a solution to the problem ... since the data in the LookUp table in Sheet1 is not sorted in Ascending order, and an exact match is needed, the 4th argument of 0 is needed in use with the VLOOKUP function; also I have used a single array formula to pull values for multiple columns and multiple rows