Help needed on how to combine LEFT into a VLOOKUP formula

Hello

I have a spent a while trying to figure this out, but can't quite get my head around how I incorporate the LEFT function into a VLOOKUP formula so that it only returns the first letter of the value it's returning.

My formula is..

=IF(A6="","",VLOOKUP(A6,'Portfolio Overview'!C:G,5,FALSE))

And some of the possible values it can return are 'Discretionary' or 'Sustainability'. Where do I add the LEFT function to this to make it only pull back 'D' or 'S'?

Really appreciate anyone's help..

Regards
Tom

Try this:

=IF(A6="","",LEFT(VLOOKUP(A6,'Portfolio Overview'!C:G,5,FALSE)))

If you only want 1 letter, there is no need to specify the 1.

Hope this helps.

Pete

Cheers, Pete - works perfectly.

Regards
Tom