Hi all, I have a list say, 1 to 5 in col A and in B1, the user will enter a number, say X, and in C1, i want the result after searching the value of X thru A1:A5. For ex, if X=4, then C1= "number present" ; OR if X=6 , C1="number absent"..... Any help will be highly appreciated.. Thanks !
Either
=IF(ISNUMBER(MATCH(B1,A1:A5,0)),"Number Present","Number Absent")
or
=IF(COUNTIF(A1:A5,B1),"Number Present","Number Absent")
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
Done.. It worked Thanks !!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks