Check if the value of one cell can be found in a number of other c

  • Thread starter Thread starter James T Kirk
  • Start date Start date
J

James T Kirk

I am trying to compare a register of members with member-IDs to a list of
members who would like to close their membership but I haven't found a good
way to compare the value of one cell with the value of several cells (a
column) thereby checking if any value from cell A1 can be found in any of
cells B1 to B100 and the same for A2, A3 and so fourth.

Any suggestions?
 
Use Conditional Formatting.

Click on A1 and:

Format > Conditional Formatting... . Formula is >
=COUNTIF($B$1:$B$100,A1)>0
then pick a nice color

Finally copy A1 and paste/special/formats down the remainder of the column.
 
Hi
Look at the help for VLookup

=vlookup(A1, "$C$1:$E$300", 3, false)

will search the first column in "$C$1:$E$300" for the value in cell
A1. If it finds it, it will return the contents of the corresponding
column 3 entry. If A1 is not found you get an #N/A error. The false
bit means that "$C$1:$E$300" is not sorted.

regards
Paul
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Check a value every time excel is loaded 1
Macro to find the value of adjacent cell from a range of values 2
check the value in cell 1
Within Tolerance ? 1
Set value of a cell with a dropdown list during run time (C#) 10
Macro - reads cells in a column .If keyword found moves cell conte 5
How to dynamically change the list in drop down list based on thevalue of another cell? 1
How do Excel display Cell values and stores internally? 5

Back
Top