VLookup Part of Text String

[Shazz]

Hi,

Can any one advise me how I look up just the Letters in a code, I have the below code which works fine if I want to look up "ULKY5312" but I just want to lookup the Letters only.

=VLOOKUP(B5,Project_Approvers,2,TRUE)

Your help would be greatly appreciated.

Shazz

 

[Marcelo Branco]

A small data sample along with expected result would be helpful.

M.

 

[JazzSP8]

Hi - We're going to need more information on this

Is it always 4 letters on the left?

If so then you can do;

=VLOOKUP(Left(B5,4),Project_Approvers,2,TRUE)

If not then if you could post back with as much info as possible that'd be good.

 

[Shazz]

It is always 4 Letters to the left, Annoyingly I cannot upload Examples, I have tried

[COLOR=#574123]=VLOOKUP(Left(B5,4),Project_Approvers,2,TRUE)[/COLOR]

But this is coming up as an error, Can I PM you a example for you to look at JazzSP8?

Shazz

 

[Marcelo Branco]

I think you need an exact match, so the last parameter of VLOOKUP should be FALSE

See if this works
=VLOOKUP(LEFT(B5,4)&"*",Project_Approvers,2,FALSE)

M.

 

[Shazz]

Thanks that worked a treat.

 

[Marcelo Branco]

You are welcome. Glad to help.

M.