Solved

searching for column data

Posted on 2013-11-22
3
237 Views
Last Modified: 2013-11-22
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
Comment
Question by:Seth Simmons
3 Comments
 
LVL 5

Accepted Solution

by:
Lawrence Barnes earned 250 total points
ID: 39669704
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
 
LVL 23

Assisted Solution

by:NBVC
NBVC earned 250 total points
ID: 39669742
or:

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

copied down.

this will return TRUE if found, FALSE if not.
0
 
LVL 34

Author Closing Comment

by:Seth Simmons
ID: 39669806
thanks guys...both work for me
0

Featured Post

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

813 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now