IF and Vlookup Functions Combine to analyse Data

[Ayesh856]

I have multiple options combined in a column and want to analyse that data. e.g. there are options

Education of children, marriage of children
None
Education of children, Marriage of Children, Business Start-Up
Education of Children, Land Purchase for House Construction, Home Construction, Business Start-Up
and the same goes.................

I want excel to add 1 in the next column if there is education of children in my first column.

Just though if and vlookup formula combine can help. But not able to find right ix of formula.

Can anyone help please.

The formula I am using is:

IF(volookup("education of children",A2:B102,2,0)=education of children,1,0)
[TABLE="width: 249"]
<colgroup><col></colgroup><tbody>[TR]
[TD] [/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[etaf]

it will only find the first occurrence of "education of children"
and is that the word that is in the cell


IF(vlookup("education of children",A2:B102,2,0)="education of children",1,0)
as you copy this down the range the range will also change
A3:B103 - A4:B104 etc

If you just want to add a 1 to the same row as the data

then you dont need vlookup

= IF(A2 = "education of children",1,0)

Otherwise can you describe how your data is structured
Or perhaps add a sample spreadsheet to a share like
onedrive or dropbox and post the link here

 

[MARZIOTULLIO]

Hi

may be

B1= --ISNUMBER(SEARCH("Education of children",A1)) Copy down[TABLE="width: 320"]
<tbody>[TR]
[TD="colspan: 5"][/TD]
[/TR]
</tbody>[/TABLE]

 

[Ayesh856]

It worked, Thank you so much MARZIOTULLIO and etaf both of you