I am looking for a function that will enable me to do that following:


1. Look for the following possible values from Worksheet 2 Column A:

Row/Column Value
A1 = AAA
A2 = BBB
A3 = CCC
A4 = DDD

2. In the contents of Worksheet 1 Column B, where possible values are as below amongst others:
xxAAAxx
xxxBBBxx
CCCxxx
xxxxxDDD

and return AAA, BBB, CCC, DDD, etc in Worksheet 1 Column A.

Thanks for the assistance!