Match?How

[Krefty]

How do you tell one worksheet to take Cell B2 fron for
example CAT worksheet and then tell Excel to find a exact
match on for example the DOG worksheet, and if a MATCH
then return that same Row and the data on the column
touching the matching cell?

Thanks in ADVANCE...

 

[Max]

Try something like
: =OFFSET(Dog!$A$1,MATCH(Cat!B2,Dog!B:B,0)-1,1)