python Search a string in a column, and return another column value from that same row
<p>I am currently trying to write a script that will evaluate a spreadsheet to search column A for a string, and then once it finds that string, print the value of column I in the same row. So far I have the following code but it isn't getting me very far. </p>

<p>any help will be appreciated. </p>

<pre><code>import openpyxl
wb = openpyxl.load_workbook("2016_SF.xlsx", data_only=True)
ws = wb["161226-161228"]
last_r=70
search_str = raw_input("What plant are you looking for? &gt; ")
last_r = cell.row


def FindXlCell(search_str,last_r):
    for row in ws.iter_rows(row_offset=last_r):
        for cell in row:
            if (search_str == cell.value):
                print(search_str, last_r, cell.row,)
</code></pre>