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 !
Bookmarks