help with matching if

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

augustus - 14 Jul 2006 10:06 GMT

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

Reply to this Message

Dave Peterson - 14 Jul 2006 15:07 GMT

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.
[quoted text clipped - 18 lines]
> augustus's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=36352
> View this thread: http://www.excelforum.com/showthread.php?threadid=561397

Signature

Dave Peterson

Reply to this Message