Google Spreadsheet Post #1637
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. May-15-2014
post by: Hamza kamal (https://productforums.google.com/forum/#!mydiscussions/docs/Baeap4e6-bM)
How to self populat cells with dropdown lists
https://docs.google.com/
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
No comments:
Post a Comment