tonywatsonhelp
Well-known Member
- Joined
- Feb 24, 2014
- Messages
- 3,197
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
Hi Everyone,
OK so I have A product name is cell J7,
then I have all my products listed in range N2:Z100
In column M I have the manufacture's names,
I want a formula that can look at the name in J7, find it in the range N2:Z100,
Find the name of that lines manufacturer and return the manufacturer's name.
Please help if you can
Thanks
Tony
OK so I have A product name is cell J7,
then I have all my products listed in range N2:Z100
In column M I have the manufacture's names,
I want a formula that can look at the name in J7, find it in the range N2:Z100,
Find the name of that lines manufacturer and return the manufacturer's name.
Please help if you can
Thanks
Tony