Vlookup Formula correction

[Suresh Kusunuri]

Hi All,

I enclosed here my workbook screen shot for rectify the formula.
Can anybody please help.
Thanks
Suresh

 

[jasonb75]

This looks like the same question that you asked here

Formula based on First 2 letter of a word

Dear All, I required a formula for 3rd column of Table 2 based on Table 1 Required "Variety" based on first 2 letters (In RED) of Item code. I am attaching herewith a screenshot. Kindly advise required formula. Thanks Suresh

www.mrexcel.com

Reported as duplicate.

 

[Suresh Kusunuri]

This looks like the same question that you asked here

Formula based on First 2 letter of a word

Dear All, I required a formula for 3rd column of Table 2 based on Table 1 Required "Variety" based on first 2 letters (In RED) of Item code. I am attaching herewith a screenshot. Kindly advise required formula. Thanks Suresh

www.mrexcel.com

Reported as duplicate.

Thanks Mr. Jasonb. I din't get solution. Can you help me in this regard.

 

[Fluff]

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).