Find a value in whole spreadsheet and return a true or false answer

[ru_cheema]

Hi,

I have 2 spreadsheets.

Spreadsheet 1 = Column A has a list of applications

Spreadsheet 2 = many different columns have applications

What im trying to do is find if spreadsheet 1 column A applications are in spreadsheet 2 in any of the columns. If yes, in spreadsheet 1 Column B I would like it to return a TRUE answer. If it cant be found, then it returns a FALSE answer.

I hope that makes sense.

Thank you in advance.

Ruby

 

[John Davis]

Hi,

I have 2 spreadsheets.

Spreadsheet 1 = Column A has a list of applications

Spreadsheet 2 = many different columns have applications

What im trying to do is find if spreadsheet 1 column A applications are in spreadsheet 2 in any of the columns. If yes, in spreadsheet 1 Column B I would like it to return a TRUE answer. If it cant be found, then it returns a FALSE answer.

I hope that makes sense.

Thank you in advance.

Ruby

Maybe:

Sub rucheema()
Dim lr As Long
Dim rng As Range
Dim x As Range

Columns("B:B").Insert shift:=xlToRight

lr = Cells(Rows.Count, 1).End(xlUp).Row

For Each rng In Range(Range("A2"), Range("A" & lr))

Set x = Sheets("Sheet2").Cells.Find(What:=rng.Value, LookIn:=xlValues, LookAt:=xlPart)

If Not x Is Nothing Then

    rng.Offset(0, 1).Value = "True"
    
Else

    rng.Offset(0, 1).Value = "False"
    
End If

Next rng
    

End Sub

 

[simplyogbeni]

Simple vLookup and IF function will solve that.

 

[ru_cheema]

Hi simplyogbeni,

do you have an example of the vlookup and if statement i would use please.

thanks