No Match

[francesrivera]

Good morning everyone,

Quick question...

I need "NO MATCH" to appear in the cell rather than the value of the
closest LOOKUP match that satisfies the formula. How can I do this?

=LOOKUP(B25,'MO Add&Counter'!$E:$E,'MO Add&Counter'!$H:$H)
=LOOKUP(B25,'MO Add&Counter'!$E:$E,'MO Add&Counter'!$I:$I)
=LOOKUP(B25,'MO Add&Counter'!$E:$E,'MO Add&Counter'!$AN:$AN)

=LOOKUP(B25,MedicareOfc,'MO Ave Claims'!$T$2:$T$235)



FR

 

[UofMoo]

Here is a sample that should help.

__ A ______ B___C______ D___
1| NO MATCH__________________
2|__________4___1_______11
3|______________3_______33
4|______________5_______55
5|______________7_______77


the formula in A1 is:
=IF(COUNTIF(C2:C5, B2) > 0, VLOOKUP(B2,C25,2,FALSE), "NO MATCH"

 

[Anne Troy]

=if(isna(LOOKUP(B25,'MO Add&Counter'!$E:$E,'MO Add&Counter'!$H:$H,FALSE),"No
Match",LOOKUP(B25,'MO Add&Counter'!$E:$E,'MO Add&Counter'!$H:$H,FALSE))
************
Anne Troy
www.OfficeArticles.com

"francesrivera" <[email protected]>
wrote in message
news:[email protected]...