Hi,
this is my first post so excuse me if it sounds like a newb question.
I used this tip to help me get rid of the #N/A I was getting.
http://www.mrexcel.com/td0110.html
However, now I do NOT want an exact match to my lookup value, is there a way to use this statement without having to find an exact match?
IF(COUNTIF($A$1:$A$10,"cat"),VLOOKUP("cat",$A$1:$C$10,3,0),"no match")
this is my first post so excuse me if it sounds like a newb question.
I used this tip to help me get rid of the #N/A I was getting.
http://www.mrexcel.com/td0110.html
However, now I do NOT want an exact match to my lookup value, is there a way to use this statement without having to find an exact match?
IF(COUNTIF($A$1:$A$10,"cat"),VLOOKUP("cat",$A$1:$C$10,3,0),"no match")