tag:blogger.com,1999:blog-6799428426680372912.post7809044929030033238..comments2023-11-15T17:26:49.562+05:30Comments on iGoogleDrive: Compare value in a column and return corresponding value in the next columnKishhttp://www.blogger.com/profile/13751098853627072874noreply@blogger.comBlogger5125tag:blogger.com,1999:blog-6799428426680372912.post-48739520488527821502013-08-12T01:51:47.151+05:302013-08-12T01:51:47.151+05:30Yes, you need to add single quotes for text values...Yes, you need to add single quotes for text values... and for numeric values you don't need to add single quotes..Kishhttps://www.blogger.com/profile/13751098853627072874noreply@blogger.comtag:blogger.com,1999:blog-6799428426680372912.post-40414440429409975652013-08-11T23:07:50.499+05:302013-08-11T23:07:50.499+05:30After much experimentation, I discovered I had to ...After much experimentation, I discovered I had to add single quotes outside of the double quotes.Alzarathhttps://www.blogger.com/profile/17463247100607528427noreply@blogger.comtag:blogger.com,1999:blog-6799428426680372912.post-24280964437400188582013-08-11T22:55:07.310+05:302013-08-11T22:55:07.310+05:30After some time of examining it, I think I'm s...After some time of examining it, I think I'm starting to understand what the formula does. I'm having an issue, though. I duplicated it and am trying to get it to work on another table. Here's what I have:<br /><br />=query(Reference!A3:J;"select E where A="&C3&" order by A desc limit 1")<br /><br />The A column and C3 are strings. The formula seems to be Alzarathhttps://www.blogger.com/profile/17463247100607528427noreply@blogger.comtag:blogger.com,1999:blog-6799428426680372912.post-44120730026743071732013-08-10T09:45:23.952+05:302013-08-10T09:45:23.952+05:30I am highly appreciative. This worked almost flawl...I am highly appreciative. This worked almost flawlessly. Only thing I changed is made it '<=' so it adjusted /on/ the value. I apologize if I didn't make that clear enough. Very impressive work, thank you.Alzarathhttps://www.blogger.com/profile/17463247100607528427noreply@blogger.comtag:blogger.com,1999:blog-6799428426680372912.post-25894181211824409052013-08-10T09:41:54.402+05:302013-08-10T09:41:54.402+05:30This comment has been removed by the author.Alzarathhttps://www.blogger.com/profile/17463247100607528427noreply@blogger.com