VBA Vlookup between two workbooks

[mayaa_mmm]

I need to vlookup with two workbooks and find the match values with highlight.
Workbook A (Located in the folder path C:/Desktop/price match

MFR	date beg	date end	price
XXX-ltd	8/1/20	8/1/20	100
YYY-ltd	9/1/20	9/1/20	200
GGG-ltd	10/1/20	10/1/20	300
MMM-ltd	11/1/20	11/1/20	400

Workbook B(Located in the folder path C:/Desktop/price match

MFR	date beg	date end	price	check(outuput column)
XXX	8/1/20	8/1/20	100	Match
YYY	9/1/20	8/1/20	200	Match

by matching all the columns in workbook A with workbook B, then check (output column) should say match. -ltd in mfr of column A in workbook A should be ignored while comparing with workbook B . Since workbook B column MFR will not have -ltd

 

[braindiesel]

VBA not required... you can do this with a helper column...

Book4
	A	B	C	D	E	F	G	H	I	J	K	L	M
1		MFR	date beg	date end	price				MFR	date beg	date end	price	check(outuput column)
2	XXX4404444044	XXX-ltd	8/1/2020	8/1/2020	100			XXX4404444044	XXX	8/1/2020	8/1/2020	100	Match
3	YYY4407544075	YYY-ltd	9/1/2020	9/1/2020	200			YYY4407544044	YYY	9/1/2020	8/1/2020	No Match	Match
4	GGG4410544105	GGG-ltd	10/1/2020	10/1/2020	300
5	MMM4413644136	MMM-ltd	11/1/2020	11/1/2020	400
Sheet1

Cell Formulas
Range	Formula
H2:H3	H2	=I2&J2&K2
L2:L3	L2	=IFERROR(VLOOKUP(H2,$A$2:$E$5,5,FALSE),"No Match")
A2:A5	A2	=LEFT(B2,FIND("-",B2)-1)&C2&D2

 

[mayaa_mmm]

=IFERROR(VLOOKUP(H2,$A$2:$E$5,5,FALSE),"No Match"

Thank you for you quick update

but i getting # VALUE error for the formula
=LEFT(B2,FIND("-",B2)-1)&C2&D2
only first line worked

=LEFT(B3,FIND("-",B3)-1)&C3&D3 I m getting error as #value

 

[braindiesel]

Odd... that is the formula i used in that cell with your data...
Are you trying it on other data and there is no hyphen "-" in it?