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                  
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.