Sunday, February 3, 2013

yogi_LookUp Multiple Consecutive Field Values For Specified Starting And Ending Field Numbers


                                          Google Spreadsheet   Post  #1007
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Feb 03, 2013
post by poster: DLHS question by vf1000 said:(https://productforums.google.com/forum/#!topicsearchin/docs/DLHS/docs/pMrKbE2lJsE)

Hello guru people!?

Do you think this transpose could work with my case? 

I have tried a lot, but can't find the answer to this very helpful function.

Regards, Kyrre
---
Thank u Yogi

No, sorry. U missed the point( or I missed yours?) However, my brother got the solution. Look into my sheet one more time, it was easy.
See sheet2 and formula in line 24 a-d. Formula in cell a24,b24,c24,d24

SuperB!
---
Hello Yogi

The txt a26 was of course wrong- thank u. I have changed it to FALSE. Tank u.
New sheet added to explain the purpose of this function. Of course, if u know another way to import the row with just
one formula in column a- that would be better. Now I need one formula for every cell in the row.

Thanks!
---
Yes, Awesome!
You are the man!

This works: =VLOOKUP(B16,Sheet1!A2:D5,{1,2,3,4},0)

Is there a way to do this (1,2,3,4) in another way? (1-4) dont work, I tried it:) 
In my workbook where this formula will be used, I have about 50 colums give or take a few. It will be a loooong formula. 

Thank u a lot for helping me.  
------------------------------------------------------------------------------------------------------------
in the following I have provided a solution to a bit more generalized problem