Use vlookup only for first 41 character.

[visha_1984]

Hi Team

I have a problem with vlookup anybody help greatly apprciate.
i have attached sample workbook,with output.

[benishiryo]

hi Visha, is this what you need?
=LEFT(VLOOKUP(A2,Sheet1!$A:$B,2,0),41)

if not, let us know what is the desired output?

[NeedForExcel]

@ visha_1984

Unable to understand your problem.

If you are looking to extract 41 Chars from "SALED ORDER NUMBER" you can just use LEFT(B2,41) and then apply the Vlookup function.

Thank You,

Deep

[visha_1984]

hey,benishiryo

it work fine

Thank u very much