Data Look Up and return

[Rich4rd]

Hi all,

I was hoping you could help with the following problem. I’ve been trying to use “VLOOKUP” but must be doing something wrong or more likely, using the wrong formula completely!

In column A I have a long list of 6 digit numbers (7000+), in column B I have another, much shorter list of 6 digit numbers. If any of the numbers in column B are in column A I would like a return of ‘YES’ next to the number in column C.

Many thanks for any help!

Richard

 

[NeonRedSharpie]

You don't really need a vlookup for this. You can, but that formula would be like this:

=IFERROR(IF(VLOOKUP($B1,$A:$A,1,0)=B1,"Yes",""),"")

A little cleaner code would be:

=IF(COUNTIF($A:$A,$B3)>0, "Yes","")

 

[Special-K99]

in C1
=IF(NOT(ISERR(VLOOKUP(B1,A$1:A$7000,0))),"Yes","No")
and copy down column C

 

[misrasomendra]

Hi

Try below formula

=IF(ISNUMBER(MATCH(B1,$A$1:$A$8,0)),"Yes","No")

Adjust the range.

123456	678901	Yes
234567	841893	No
345678	458986	No
678901	123456	Yes
790012	888613	No
967756		No
114550		No
132324		No

<tbody>
</tbody>

 

[Rich4rd]

Thank you all for the quick replies! Seems to have done the job!