Returning results for an IF in a column - VBA

[Mr2017]

Hi

I've got a spreadsheet with a list of data in column H and I'd like to use VBA to return a value in column O that is dependent on the value in column H.

I’d like to search the text using the instr (in string) function then return a value if specific text appears.
Conditions:

If a cell in col. H contains the word FOR and a currency sign eg £, the corresponding cell in col. O returns "Fixed Multibuy"
If a cell in col. H contains the word FOR and a FULL STOP sign ie "." the corresponding cell in col. O returns "Fixed Multibuy"
If a cell in col. H contains the text "3 for 2" the corresponding cell in col. O returns Cheapest Free
If a cell in col. H contains the word "Extra" the corresponding cell in col. O returns "Special Purchase"
otherwise, it returns the words "Special Offer"


Please find below sample data which you can copy and paste into Excel. Please let me know if you have any questions. TIA

[TABLE="width: 1029"]
<colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]Mechanic[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]Conversion[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Half Price[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD]Special Offer[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]2 for 3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD]Fixed Multibuy[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]2 for 2.50[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD]Fixed Multibuy[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]3 FOR 2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD]Cheapest Free[/TD]
[/TR]
</tbody>[/TABLE]

 

[Michael M]

Why VBA ??
You could use this, but I don't think you have given us ALL the criteria

=IF(OR(H2="FOR",H2="£",H2="FOR."),"Fixed Multibuy",IF(OR(H2="3 for 2",H2="2 for 3",H2="2 for 2.5"),"Cheapest Free",IF(H2="Extra","Special Purchase","Special Offer")))