How to search fields and then add to value of cell using vlookup or ?
 

Hello Guru's
How would i go about searching for a 5 letter code inside the
worksheet, then using that code to search to see if it matched a code
from a lookup worksheet and then use that code to place a value inside
of some cells in VBA?

example:
worksheet1 has rows
A B C D
1 NAME CODE NAME1 NAME2
2 TEST 01-thm-THISA that THISA


worksheet2 has the lookup
A B
1 CODE NAME
2 THISA THIS IS THE NAME OF A

Note that the code 'THISA' is found in B2 and D2 and it is also in the
lookup table in A2. I am going to use both the code and name.

I want it to search the fields in the worksheet, all worksheet1
If it finds a matching code in the fields (worksheet1) with the lookup
(worksheet2) use the lookup to populate the fields E (will be the code)
and F (would be the name of the code, ie: THIS IS THE NAME OF
A)........... (which are blank and not shown in this example)
Can this be done?

Basically, i am searching for a code in all the worksheet, if it finds
a matching one in the lookup sheet, then populate some cells in the 1st
sheet.

Any help would be appreciated. Thanks

Keri~