• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 272
  • Last Modified:

searching for column data

I have 2 lists I need to search data in.  All is alpha-numeric.
I need to take one value and see if it exists in the other list.

For example, data is in both columns B and C.  I need to take B2 and then search C2:C286 and in D2 show either yes/no, true/false - whatever is possible.  Then take B3 and search C2:C286 and show a result in D3 and repeat all the way down.

I can't seem to find a function that will do this.  I've been looking around at lookup/vlookup/match and don't know if that can do what I need.

Running Excel 2010.
0
Seth Simmons
Asked:
Seth Simmons
2 Solutions
 
Lawrence BarnesCommented:
Here's an example of what I think you are asking.  True will be returned if a value in column A is found in column B.  Formula is in cell C2.  When a value is not found #n/a is returned and I'm using the ISERROR to change that to true/false.


=ISERROR(VLOOKUP(A2,B:B,1,FALSE))=FALSE

Column A Column B Value Found
AA3A     ABDC     FALSE
AA45     DKL28    FALSE
ABDC     CSKS     TRUE
DKL28    SJSK9    TRUE
SKSIQW   SKA9     FALSE
EIE89    89SKSS   FALSE

Open in new window


small array
0
 
NBVCCommented:
or:

=ISNUMBER(MATCH(B2,$C$2:$C$286,0))

copied down.

this will return TRUE if found, FALSE if not.
0
 
Seth SimmonsSr. Systems AdministratorAuthor Commented:
thanks guys...both work for me
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now