I want to Access value by using its key , the login should to be like if user enter key1 it should match with key1 keyword from excel sheet and give value_1 as output.

I want to Access value by using its key , the login should to be like if user enter key1 it should match with key1 keyword from excel sheet and give value_1 as output.

Answer 1

[Karim]

Hi, you can compare the strings of the key with the user input, and then use that index to retrieve the value:

UserInput = "key1";

MyData = ["key1" "value_1";
          "key2" "value_2";
          "key3" "value_3"];

% look for the index of the "key"
Idx = contains(MyData(:,1),UserInput);

if any(Idx)
    % extract the coressponding "value"
    MyOutput = MyData(Idx,2);
else
   disp('no matching key found') 
end

MyOutput

MyOutput = "value_1"

Answer 2

[Steven Lord]

Take a look at the containers.Map function.