Friday, August 17, 2012

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

user meph2u said: (!category-topic/docs/spreadsheets/1yaTPtQss_M%5B1-25%5D)
Hlookup (seemingly erroneously) returning "#N/A". What am I doing wrong? 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

1 comment: