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?
https://docs.google.com/
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:
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
No comments:
Post a Comment