How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask Satchi Your Own Question
Satchi
Satchi, Computer Software Engineer
Category: Computer
Satisfied Customers: 2467
Experience:  4 yrs of Hardware & Software Troubleshoot exp
18133961
Type Your Computer Question Here...
Satchi is online now

Hi, I have two lists of company names in excel. One in column

Customer Question

Hi,
I have two lists of company names in excel. One in column A, and one in column B. I want to see if the company name in column B, appears anywhere in column A. What function do I need for this?
Thanks
Tom
Submitted: 2 years ago.
Category: Computer
Expert:  Satchi replied 2 years ago.

Satchi :

Hi , Welcome to JustAnswer Thanks & Regards Satchi

Satchi :

Please provide the excel file for which you want to check

Satchi :

You can use the function as below

Satchi :
SubCompare()
DimRange1 AsRange, Range2 AsRange, Rng1 AsRange, Rng2 AsRange, outRng AsRange
xTitleId = "KutoolsforExcel"
SetRange1 = Application.Selection
SetRange1 = Application.InputBox("Range1 :", xTitleId, Range1.Address, Type:=8)
SetRange2 = Application.InputBox("Range2:", xTitleId, Type:=8)
Application.ScreenUpdating = False
ForEachRng1 InRange1
xValue = Rng1.Value
ForEachRng2 InRange2
IfxValue = Rng2.Value Then
IfoutRng IsNothingThen
SetoutRng = Rng1
Else
SetoutRng = Application.Union(outRng, Rng1)
EndIf
EndIf
Next
Next
outRng.Select
Application.ScreenUpdating = True
EndSub

Related Computer Questions