zvkmpw wrote:
I want C1 to compare B1 to A1:A14 and bring back the cell reference if there
is a match.
[quoted text clipped - 16 lines]
13 Â* Â* Â*65 Â* Â* Â*130 Â* Â*
14 Â* Â* Â*70 Â* Â* Â*140 Â* Â*

One way is to put this in C1
=IF(COUNTIF(A:A,B1)0,ADDRESS(MATCH(B1,A:A,0),1,4, 1),"no match")
and copy downward.

Modify to suit.


Great post, I am learner about excel. i need some more this type of posts
which help me to get excel knowledge.

hope you will help me in future about excel help.

Thanks !!!

_____________________
http://www.microsoftoffice-2010.com