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