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.
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.
i have two tables (A and B).
ReplyDeleteboth 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 >''