Thursday, May 15, 2014

yogi_Autopopulate Row By Row Entries In Column B Through F Based On Pattern Shown By OP In AutopopulateValidation2

                                         Google Spreadsheet   Post  #1637
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI   May-15-2014
post by: Hamza kamal  (!mydiscussions/docs/Baeap4e6-bM)
How to self populat cells with dropdown lists

The sheet "AutopopulateValidation2" contains list of Objects and their Properties. Sheet "AutopopulateValidation1" contains same objects but randomly listed. The task is to find an object in sheet "AutopopulateValidation1" and populate 5 cells right of it with corresponding Properties (Like I did manually with the first row). Kind of VLOOKUP function but instead of returning a value, populate a range.  
Maybe there are a very easy solution which I don't now?
I can not say I have clearly understood Hamza Kamal's description ... so I have gone with my hunch in providing the following solution