Using left Function to extract data based on several Criteria

I have data in Col A. I have tried to use the IF Function combined with the left function to that where 199, 200, F10, appears in Col A then Shirts COS to be extracted , otherwise a blank

See my formula below

I have also attached sample data

Please Login or Register  to view this content.

it would be appreciated if someone could assist me

The formula in your example is a Circular Reference, it's on Col B, looking at itself.

Changing it to;

Formula:

Please Login or Register  to view this content.

Seems to work as you describe?

Thanks. I amended it, but it only extracts "Shirt Cos" where code in Col A contains 199 in the fist 3 characters, but not where first three characters is 200 or F10

Thanks for your help, your formula works perfectly