How to import Excel data with variables into octave

help
#1

Screenshot 2021-01-13 145207

I have this data in excel. I need to use user input like, user inputs the word rice, Octave looks into the data, and selects the value assigned. So When I type rice in the command window, The value assigned shows up. I know how to use

  1. [num,txt]=xlsread(‘Filename’)
    But I don’t know how to proceed from there
#2

Try to use strcmpi.

#3

How does comparing two strings help?

#4

Did you even bother to read the documentation for that function?
IIUC, you are trying to find the position in column A where the user string matches and return the corresponding value from column B. strcmp is the function that could do half of that for you…