IF, Then Statement Using Multiple Worksheets

[chinxster]

Hello,
I'm trying to work out a formula that would use an if, then statemen
between two worksheets. Then again, I don't know if the IF,THE
statement would even apply. Here is the problem:

Worksheet 1:
Column A Column B
Sarah 5
Bill 2
Joe 15
Meredith 10

Worksheet 2:
Column A Column B
Ted 2
Sarah 4
Phillip 10
Joe 2

Now, I need to get Column B from Worksheet 2 to multiply with Column
from Worksheet 1 by matching up the names from Column A in bot
worksheet. How do I do that? For example, if there is a name i
worksheet 2, column A that matches with worksheet1, column A, the
worksheet 2, column B would multiply with worksheet 1, column B. So fo
example, Sarah would be 4*5=20. I tried doin
IF('Worksheet2'!A1:A4='Worksheet1'!A1:A4
('Worksheet2'!B1:B4)*('Worksheet1'!B1:B4),0). Any help would b
appreciated. Thanks!

Glend

 

[Andy B]

Hi

Try this:

=IF(ISERROR(VLOOKUP(A2,'Worksheet 1'!A2:B50,2,FALSE)),B2,VLOOKUP('Worksheet
1'!A2:B50,2,FALSE)*D3)

in C2 on Worksheet 1.

Andy