tag:blogger.com,1999:blog-8807805591547673516.post2300088186065489203..comments2024-02-28T08:14:50.756-08:00Comments on Cloud Computing -- Google Docs Way: yogi_Set Up A Sheet For Using Vlookup Functionality For Different Formulas Not ValuesYogi Anandhttp://www.blogger.com/profile/10862524957172908621noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-8807805591547673516.post-15658384288820409762012-09-23T09:08:48.744-07:002012-09-23T09:08:48.744-07:00Hello, Yogi.
Thank you very much for your help wi...Hello, Yogi.<br /><br />Thank you very much for your help with my questions. I would appreciate if you could also comment on the last one.<br /><br />Regards,<br />LeonAnonymoushttps://www.blogger.com/profile/10476963027014243706noreply@blogger.comtag:blogger.com,1999:blog-8807805591547673516.post-46258973397488064972012-09-16T23:45:03.488-07:002012-09-16T23:45:03.488-07:00Sorry everyone for the delay, I was away.
Yogi,
...Sorry everyone for the delay, I was away.<br /><br />Yogi,<br /><br />1. Thanks for the solution with vlookup. I would need a solution without ArrayFormula because I need to transport the file to MS Excel sometimes.<br />1a. Assume, I use your vlookup solution. Then if I need a big mass of information, could I expect that vlookup of big array (you proposed B32=vlookup($A17,$A$3:$J$6,column(B:B),0), where $A$3:$J$6 is a relatively small array) will not slow it all down?<br />1b. May it be done differently (because your vlookup solution actually lookups values, not formulas). Is it possible to have the same output values (by dragging formula to the rate as far as needed, not only to J column), but assuming you can use as input only $A$3:$C$6, not $A$3:$J$6?<br /><br />2. In the spreadsheet I shared first I've made a tab "A1+1". As I put "=A2" in A3, it merely returns "A1+1", but it doesn't return "2".<br /><br />Thanks in advance for your help.<br /><br />Cheers,<br />Leon.Anonymoushttps://www.blogger.com/profile/10476963027014243706noreply@blogger.comtag:blogger.com,1999:blog-8807805591547673516.post-59763172029096818462012-08-31T08:49:52.068-07:002012-08-31T08:49:52.068-07:00Hi Leon Ivanov:
In regard to 1. YES it is possibl...Hi Leon Ivanov:<br /><br />In regard to 1. YES it is possible to have a single cell non-array formula for what is hown in cell B17 (although I don't know why you would want to do that) I have updated my blog post to shown the single cell formula in cell B32<br /><br />now for 2., in cell A3 you will key-in the formula =A2<br /><br />Cheers!<br />Yogi<br />Cloud Computing -- Google Docs Way<br />yogi--anand-consulting.blogspot.com<br /><br />Yogi Anandhttps://www.blogger.com/profile/10862524957172908621noreply@blogger.comtag:blogger.com,1999:blog-8807805591547673516.post-40084537437347098242012-08-31T01:41:52.601-07:002012-08-31T01:41:52.601-07:00Thanks very much, Yogi.
Everything works, but I g...Thanks very much, Yogi.<br /><br />Everything works, but I guess I just didn't ask the right question:<br />1. Is it possible to make it without ArrayFormula in B17? I'm generally comfortable copying formula throughout the sheet<br />2. Generally speaking, how to quote o formula?<br />For example, A1=1, A2 has A1+1 as Text. <br />What should I put in A3, to get A1+1 in A3 as Formula, but by referencing only A2 from A3?<br /><br />Cheers,<br />Leon.Anonymoushttps://www.blogger.com/profile/10476963027014243706noreply@blogger.com