Saturday, February 4, 2012

yogi_Match A Specified Phrase In Column A of SpreadsheetB And Pull Data From Matching Row In Column F

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                            www.energyefficientbuild.com
user DjDurland said:
Ok so, I have a friend that has their own Spreadsheet. What I would like to do is, have my spreadsheet search theirs in the A column for a specific word. Once it finds that word, I want it to return the value in the F column, same row. Example:
Search A column for "Crash". Once it finds "Crash", return F column of the same row, which is "20".
Any idea how I do this?
------------------------------------
following is a solution to the problem

I pulled into SpreadsheetA (poster's spreadsheet) the required matching data from SpreadsheetB (poster's friend's spreadsheet.

1 comment:

  1. i have two tables (A and B).
    both match on fields 'Vorname'+'Zuname'.
    when entries match on key i wish to copy field 'tel' from table A to table B.

    A -> https://docs.google.com/spreadsheet/ccc?key=0AoeGzY4Bn-GGdGhwOWl2dUJlaGpKandYYlhDdDNMaFE&hl=en_GB#gid=0

    B -> https://docs.google.com/spreadsheet/ccc?key=0AoeGzY4Bn-GGdENxYWtQVVJvMUR1TzlKZ2lBNzRtMWc&hl=en_GB#gid=0

    tobe precise, dield 'tel' in table A is one of four fields. i wish to take the very first one found >''

    ReplyDelete