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