Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

searching for column data

Posted on 2013-11-22
3
Medium Priority
?
269 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 5

Accepted Solution

by:
Lawrence Barnes earned 1000 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 1000 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 35

Author Closing Comment

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

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa‚Ķ

618 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