Change Vlookup Return Value using IF, LEN and Vlookup

[omcsarayar]

Hi everyone,
I am currently struggling to manipulate the return value of vlookup using the combination of IF, LEN and Vlookup
If from Sheet A it returns "Male", i need the value in Sheet B to be "M". if not then just blank.

i'm relatively new to excel or google spreadsheet, so i have included my spreadsheet link to better explain my current situation. (it's a sample, but the same format as my real sheet)
my spreadsheet link: Work sample

as you can see on the spreadsheet i tried using this formula:
=IF(LEN(VLOOKUP(B2,A!A2:F8,3,0))=Male,"L",VLOOKUP(B2,A!A2:F8,3,0)"")
but it doesnt work, it returns #ERROR

is there a way for me to do this?
any help will be much appreciated.

 

[Fluff]

Hi & welcome to MrExcel.
How about

=IF(VLOOKUP(B2,A!A2:F8,3,0)="Male","M","")

 

[omcsarayar]

Hi & welcome to MrExcel.
How about

=IF(VLOOKUP(B2,A!A2:F8,3,0)="Male","M","")

omg, it works. thankyouu so much!
now i see i've overcomplicate the formula, such a noob haha. thankyou again)

 

[Fluff]

Glad to help & thanks for the feedback.