• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

look up [SOLVED]

madocar

madocar

Member
Hello,


Can you help pls.

In column A I have numbers. Column B consists of a lot of numbers as well. And I want to look up if number in A1, A2 ... is in B1:B500 array. If value in A1 is in B1:B500 array I want to see "yes" as an output
 
Hi Madocar


It is hard to know from your question whether you want to test one condition or both at the same time.


Here is a simple solution for one at a time.


=IFERROR(IF(MATCH(A1,$B$1:$B$500,0)>1,"YES"),"NO")


There may be better ways to represent this though. But it gets the conversation started.


Take care


Smallman
 
You must log in or register to reply here.
Back
Top