Large Formula Combination Trouble

[Guest]

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.

 

[JE McGimpsey]

One way:

Tab2, Column D:

D1: =IF(ISNA(MATCH(C1, Tab2!A:A, FALSE)), "", VLOOKUP(C1, Tab2!A:B,
2, FALSE))

Note that worksheet functions can't insert values in other cells.