Need to get data from other worksheet cells... matching some things en route

[Jennifre]

Hi, everyone is so helpful on here, I feel super grateful, and very thankful I've been able to learn so much about Excel, here, thank you!!

A new issue I am having: I need to get data from another cell on another sheet in my document. To get it, I need the cell whose formula calls this data to match two columns, then report back to this cell what value is in that "matching" row's cell XX.

Example, I need to do something like this:
IF A1 matches T1, tell me what's in MM1.

Example data (from worksheet "old" to be placed on worksheet "new"):
A
1111
1321
3222

T
1111
1321
3222

MM
1.81
2.45
1.09
That kind of thing. THANK YOU!!

 

[Robert Mika]

Hi ,
If your data in columns A and Tare exactly in the same postion in both columns you can use:
=IF(old!A1=old!T1,old!MM1,"no match")

 

[Jennifre]

Unfortunately no, they are not in exactly the same spot. I've been moving / adding things since replicating the worksheets.

Any other solution? Thank you so much for your query and response!!!

 

[Jennifre]

Hi, thank you so much. I can't tell [yet] whether this will work for me or not.

And I realized that, ideally, I'd like to be able to add one more "criteria" of this formula, to say instead:

If A1 = otherworksheetA1 and otherworksheet N1, then tell me what's in M1.

Is that possible? Thank you so much, this one has had me foiled for... too long.

Thank you so much, I really, really appreciate your help!~

 

[Jennifre]

Hm, I found this, but... am too dumb to understand how this can work to match THREE cells, to find the cell whose value I need this formula to report.

If anyone can tell, please let me know. Again, thank you so much!

What I found:

=if(VLOOKUP(A2,'WorksheetName'!A:C,3,0)=0,"",VLOOKUP(A2,'WorksheetName'!A:C,3,0))

But in this, I cannot tell what the pieces refer to here?

Again, I am hoping to find three cells in another worksheet that match, and where they match, give me the value in another column. Like this:

IF A1 matches C1 and E1, then tell me what value is in M1.

Hopefully someone can help; thank you!!

 

[Robert Mika]

Hi,
The formula means:

Find Value from A2 in Column A of "WorkSheetName" sheet and return coresponding value from column C.
If this value is equal 0 then do nothing(return "") but when the value is diffeent that 0 retrn this value.

In your case try this:

=INDEX($M$1:$M$100,MATCH(1,(H2=$A$1:$A$100)*(H2=$C$1:$C$100)*(H2=$T$1:$T$100),0))

(array formula confirm CTRL+SHIFT+ENTER)

where H2 host the value you are looking for.