help with matching if

A

augustus

As you can see I am totally a noob to excel. And I have another noo
problem needed to be solve. can someone please help me once more.
Quetion #2: per say, I have a table of data, and I would like to exce
to return the matching values from the table to a2.

for example:
[ ]|Y1 |Y2| Y3|
X1|.54|.65|.67|
X2|.56|.67|.89|

cell A1=Y1
cell A2=X1
A4 will return the matching values from y1,x1=.54

Thx for the help everyone.
Highly Appreciated
 
D

Dave Peterson

It sounds like =index(match(),match()) would work for you.

Debra Dalgleish has some instructions:
http://contextures.com/xlFunctions03.html

Look at example 2.
As you can see I am totally a noob to excel. And I have another noob
problem needed to be solve. can someone please help me once more.
Quetion #2: per say, I have a table of data, and I would like to excel
to return the matching values from the table to a2.

for example:
[ ]|Y1 |Y2| Y3|
X1|.54|.65|.67|
X2|.56|.67|.89|

cell A1=Y1
cell A2=X1
A4 will return the matching values from y1,x1=.54

Thx for the help everyone.
Highly Appreciated.
Click to expand...
 
Top