Using part of data for if statement

[OcMac]

I want to write an if statement to to open one of two documents based on the data in a cell, but only part of the data.

For example, data in the cell could be aaorange09, bbapple09, aaround09, bbpear09 etc. The point being that the first two letter are the constant and what I want to use to determine which file to open.

strCode is where the data is stored.

If strCode = "first two letters AA" then Open file A
else
open file B

Thank you for your help,
Matt

[judgeh59]

give this a try - untested

Please Login or Register  to view this content.