I have 2 workbooks. In workbook (1), I have a column with a few thousand store names. In workbook (2), I have a column with a few hundred store names. The store names are not identical but have the following unique words/numbers: ABC123 etc. I want to identify if a store in workbook (2) exists in workbook (1). I have attached a sample file.
Thanks in advance.
Select B2
Conditional Formatting
New Rule
Use a formula to determine...
=NOT(ISNA(VLOOKUP(A1,B$1:B$8,1,0)))
Format as green
Use Format painter (paintbrush icon) to copy to other cells
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
You would need to use Conditional Formatting to do that.
Select column A, go CF, New Rule, and choose Use a formula to determine...
Enter formula:
=SEARCH(C$2,A2)>=1
Select formatting in click Ok.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
In CF rules
Formula:
Please Login or Register to view this content.
How can you use Conditional Formating.
--In Excel 2007 and 2010, Conditional Formatting is in the Styles group on the Home tab. In Excel 2003, Conditional Formatting is on the Format menu. See here how you can work using CF.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Select b2:b8
and use below formula in condition format and change format as per your requirement
=ISNUMBER(SEARCH(" "&C$2&" "," "&B2&" "))*1
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
I looked at this a little differently. Seeing that there are a few hundred names to be considered, I assumed that there would be maybe a few hundred unique numbers or words to be compared with.
For workbook 2 I used this formula to draw the names from workbook 1 that matched the keywords or numbers in workbook 2 with the results entered in column H
Formula:Please Login or Register to view this content.
I then used this formula in conditional formatting to highlight the names that matched the keywords or numbers in workbook 2
Formula:Please Login or Register to view this content.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
Thanks very much to all for your response. There are a few hundred unique numbers or words and newdoverman's solution works perfectly.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks