Nel post
*njuneardave* ha scritto:

Wow, thanks Franz, that worked great. Now a follow-up question: I
am having
the same problem using INDEX and MATCH....here is what I have:


=IF(INDEX(Sheet2!$B$2:$B$9000,MATCH(1,(Sheet1!$A$2 :$A$9000=Sheet2!$A2)*(Sheet1!$E$2:$E$9000=Sheet2!$ E2),0))
<
INDEX(Sheet1!$B$2:$B$9000,MATCH(1,(Sheet2!$A$2:$A$ 9000=Sheet1!$A2)*(Sheet2!$E$2:$E$9000=Sheet1!$E2), 0)),
INDEX(Sheet2!$B$2:$B$9000,MATCH(1,(Sheet1!$A$2:$A$ 9000=Sheet2!$A2)*(Sheet1!$E$2:$E$9000=Sheet2!$E2), 0)),
"")


I am trying to see if the value in sheet1 and sheet2 that are
respective to
their identifiers (in columns A and E) are equal. If they are equal,
i dont
show anything, but if they are different, I want to show the value in
Sheet2.
Is this formula way over complicated? Also, can i use indirect on
this
formula to get rid of the #N/A references?

Yes, in the same manner I showed you in my last post...

Thanks in advance!

You're welcome (in advance...)


--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy