Hi,
I have 2 worksheets. Need to look up B col description (contains text and numbers) in worksheet 1, and match with Col B in worksheet 2, return value from col G. If I use match partial text, it returns wrong value from col G. If I match exact description, it returns #N/A.
Please help me. Thanks.
Vinnie
Bookmarks