compare columns & Display output using excel sheet

1 次查看（过去 30 天）
Dimple
Dimple 2013-8-5
i have 3 columns in abc.xlsx and the data is
X Y Z
1 1 10
1 2 20
1 3 30
1 4 40
1 5 50
2 1 60
2 2 70
2 3 80
2 4 90
2 5 100
3 1 110
3 2 120
3 3 130
3 4 140
now user will enter any two values that i want to match with X and Y Column once the match is found then i want to display corresponding c column cell value
for eg: My input is 2 and 3 then i want to display the value 80

请先登录，再回答此问题。

采纳的回答

Azzi Abdelmalek
Azzi Abdelmalek 2013-8-5
编辑：Azzi Abdelmalek 2013-8-5
A=[ 1 1 10
1 2 20
1 3 30
1 4 40
1 5 50
2 1 60
2 2 70
2 3 80
2 4 90
2 5 100
3 1 110
3 2 120
3 3 130
3 4 140]
x=2,
y=3,
out=A(ismember(A(:,1:2),[x y],'rows'),3)
  7 个评论
显示 5更早的评论
Dimple
Dimple 2013-8-6
i want to create a gui with two input dialog boxes.
User will enter the values.
After that i want to compare the user entered values with excel sheet two column's cell values.if the match is found then it has to display the 3rd column value as the answer
Dimple
Dimple 2013-8-20
Suppose if x and y values are from prompt.then how to read values for x and y

请先登录，再进行评论。

更多回答（1 个）

Dimple
Dimple 2013-8-20
prompt{1}='Enter 1st grade :'; prompt{2}='Enter 2nd grade :'; name='result'; answer=inputdlg(prompt,name); a=xlsread('inputdata.xlsx');
excel file values are
0.1 0.1 0.1 0.1 0.2 0.1 0.1 0.3 0.1 0.1 0.4 0.2 0.1 0.5 0.2 0.1 0.6 0.2 0.1 0.7 0.3 0.1 0.8 0.3 0.2 0.1 0.1 0.2 0.2 0.2 0.2 0.3 0.2 0.2 0.4 0.2 0.2 0.5 0.3 0.2 0.6 0.3 0.2 0.7 0.3 0.2 0.8 0.4 0.3 0.1 0.1 0.3 0.2 0.2 0.3 0.3 0.2
1st grade values are in 1st column 2nd grade values are in 2nd column
if user enter values for 1st and 2nd grade, then it has to display the output. output is the corresponding 3rd column value.
for eg: Enter 1st grade : 0.2
Enter 2nd grade :0.8
output is 0.4
  1 个评论
Azzi Abdelmalek
Azzi Abdelmalek 2013-8-20
Dimple, is this an answer or a question? If you want to ask a new question, post a new one in Ask a question

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by