Hi I have 2 sheet with data and I need to link using vlookup.

Sheet 1
ABC Ltd
Corporate LLP
Delta, Mbh

Sheet 2
ABC
Corporate
Delta


Problem facing in sheet 2 "ltd, LLP, Mbh" is not mention.

I need to use vlookup to extract the data to sheet 1 and there is 4000 rows there in excel.

Any Excel guru have a solution