formula if approximate or randomly match

[Rajendar]

Hi,

I need formula in excel.

Sheet name : Master list
Sheet name : Sheet2

I have item code and item description in the master list.
in Sheet2 I have only items description need formulas if Approximate match item description return item code in sheet2

Herewith attached Sample data sheet

Thanks & Regards
Aelmareddy

 

[rahulshewale1]

hii @Rajendar ,


see if is ok ?

Cell in B2

=VLOOKUP("*"&A2&"*",CHOOSE({1,2},'MASTER LIST'!$B$2:$B$10,'MASTER LIST'!$A$2:$A$10),2,FALSE)



Regard
Rahul shewale

 

[Rajendar]

Hi Rahul,

Sheet 2 row A3 item description starting i given space that time there is no code

is it possible before the item description there was space in some cases

 

[Rajendar]

Rahul,

The same way i copied and paste the formula the error message is N/A

 

[Rajendar]

Previously Wrongly attached.

See the vlookup sheet..

 

[rahulshewale1]

Hii Rajendar,


Could you please provide real more data ? we might be help you.


Regard
Rahul shewale

 

[Rajendar]

Dear Rahul,

I sending full data. Please see the attachment

Best Regards
Aelmareddy

 

[Rajendar]

Hi,
Rahul,

Did you find any formula..

 

[rahulshewale1]

Hii

Sorry buy data layout is different that why I couldn't provide formula . might be excel nija can help you ...