Wednesday, August 14, 2013

yogi_Pull Data For Select Columns For Matching Value of Equipment In Another (Submissions) Sheet

                                          Google Spreadsheet   Post  #1334
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Aug, 14 2013
user Wisdomless1 (http://productforums.google.com/forum/?zx=a0wkoqyr2dyg#!category-topic/docs/spreadsheets/_mgjPrzB1V8)
Querying to select and trim to only the first row matching criteria
https://docs.google.com/spreadsheet/ccc?key=0AlDD-0aeaKbHdEF0dHBhU19UR3BSd0FpaWpIcFM5V0E&usp=sharing

Hello, I'm trying to work on querying submissions made from a Google Form so that only the most recent entry shows.

In the sheet I shared for this example, I want to make a function in cell B8 such that it only selects the row in columns A, B, & D that matches the value in A8.

As far as I can get would be:

=query('Submissions'!A2:D, "select A,B, and D where C=X-16")

But this will also add the second row that contains this value.  I also can't seem to figure out how to get it to reference A8 as X-16 instead of having to typing it in manually.

I don't know how to trim it or whatever, but I would really appreciate any help on this matter!
------------------------------------------------------------------------------------------------------------------------------------------------