If Statement based on text

[Leebles]

Hi,

I'm currently having issue where I'm trying to return a text value based on the start of a code.

For example, a cell might have the text D469/M081.

I grab the first 4 characters with Left(C3,4)

I want to return a text value with an IF statement like this:

If(Left(C3,4) = D469,CompanyName,A3)

The obvious problem is that D469 is referencing a cell, so I've tried with quotations like so:

If(Left(C3,4) = "D469",CompanyName,A3)

But that returns the #NAME error.

Can anyone offer any suggestions as to a way around this?

Many thanks

 

[VoG]

Try

If(Left(C3,4) = "D469","CompanyName",A3)

 

[Comfy]

That should work without the quotes.

What does CompanyName represent?

Avlookup or just some text

 

[Leebles]

CompanyName represented some text. VoG's solution appears to have worked.

Thankyou very much :D

 

[Michael M]

Hi and welcome to the Board
What is CompanyName ?
Is it a named range, a vlookup....??
Just changing the formula to test, try

=IF(LEFT(C3,4) = "D469","CompanyName",A3)