tag:blogger.com,1999:blog-8807805591547673516.post3622216108266115541..comments2024-02-28T08:14:50.756-08:00Comments on Cloud Computing -- Google Docs Way: yogi_Align Columns Of Data Using One Comment FieldYogi Anandhttp://www.blogger.com/profile/10862524957172908621noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-8807805591547673516.post-48433717412474286612012-02-28T13:44:08.093-08:002012-02-28T13:44:08.093-08:00Hi Carlos HG:
I know what you mean now ... I had ...Hi Carlos HG:<br /><br />I know what you mean now ... I had used the same VLOOKUP function twice and used the INDEX function with the same VLOOKUP function to pull the values from the first and second column, and you used different VLOOKUP functions ... once to pull values from one column and then a different VLOOKUP function to pull the value from the second column.<br /><br />I had thought you meant you were able to do what I did using VLOOKUP function only once.<br /><br />Cheers!<br />YogiYogi Anandhttps://www.blogger.com/profile/10862524957172908621noreply@blogger.comtag:blogger.com,1999:blog-8807805591547673516.post-75088704134050169562012-02-28T12:43:42.849-08:002012-02-28T12:43:42.849-08:00Hi Yogi,
In my first comment I tried to explain ...Hi Yogi, <br /><br />In my first comment I tried to explain that the formula doesn't need any index function.<br />I use the next formula in a copy of your spreadsheet and is working:<br /><br />=arrayformula(if({1,1,1,1,1,0,0},A2:E,if({0,0,0,0,0,1,0},iferror(vlookup(D2:D,F2:G,1*row(D2:D)^0,0)),iferror(vlookup(D2:D,F2:G,2*row(D2:D)^0,0)))))<br /><br />Cheers !Carlos HGhttps://www.blogger.com/profile/12361718169920087891noreply@blogger.comtag:blogger.com,1999:blog-8807805591547673516.post-68907787109247378212012-02-24T20:16:54.617-08:002012-02-24T20:16:54.617-08:00Hi Carlos HG:
Thanks for your comment ... however...Hi Carlos HG:<br /><br />Thanks for your comment ... however, I just checked again, and from how I look at it I need both of the INDEX functions. Would you please elaborate and perhaps share reference to a spreadsheet or an image where my formula using only one index function does the job.<br /><br />Cheers!<br />YogiYogi Anandhttps://www.blogger.com/profile/10862524957172908621noreply@blogger.comtag:blogger.com,1999:blog-8807805591547673516.post-59336784234981352732012-02-24T11:42:38.070-08:002012-02-24T11:42:38.070-08:00I run the formula without the two index functions ...I run the formula without the two index functions and it also works fine.<br /><br />Cheers !Carlos HGhttps://www.blogger.com/profile/12361718169920087891noreply@blogger.com