hi community

how can i match data between two worksheet.....

example:

in worksheet A

I have a company name - AAA Pte Ltd

in worksheet B

I also have the company name - AAA Private Limited , with tel number

I wanted to find and match AAA Pte Ltd (worksheet A) with AAA Private
Limited in (worksheet B) to display the tel number.

can anybody kindly enlighten me on how can I do this?

thanks community for the assistance

:)


--
oldLearner57