I will create the scenario to better help explain.

On Tab 1 I have Column A and B
On Tab 2 I have Column C and D

I want to take the value from the cell in column A with in Tab 1
Find that text in Tab 2.
If found then in Tab 2 column C then in column D insert the value from Tab 1
column B

Is this possible? Could someone show me how? I have learned allot in Excel
but this one is trumping me. Thank you for any help you may give.