Sunday, January 5, 2014

yogi_Use VLOOKUP In Google Old Sheets For MultiColumn Search_Key

                                          Google Spreadsheet   Post  #1473
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI   Jan-05-2014
question by mcjtom (!category-topic/docs/spreadsheets/SRGdEhVvdFc)
Adam's/ahab's Vlookup as array formula - multicolumn search criterion?
I was playing with the Adam's/ahab's amazing machine:


By mistake I change the first Vlookup argument to multi-column array (A2:B). The formula still worked, but what does it actually do?  

Is the first column of 'Helper_01'!A:I range compared to either of both columns of the A2:B search criterion, or just one of them (but which one)?