How to search specific columns and return specific values in python using Google spreadsheet?
I’m having trouble getting this to work. Essentially I want a user to input a keyword and then get a question and answer pair as a return. The first, second, and third columns in the the spreadsheet has the keywords, while the fourth and fifth columns have the question and answer respectively. I want to have it so that the program only searches the first three columns for the keyword, and then only returns the 4th and 5th column from any row that contains that keyword.