Reference / retrieve data from a table and populate a table in a different workbook?

I've been struggling with how to use data from two different columns (A & B in Target.xls) to get a number from a specific cell in a different file (Source.xls) and return the value of the referenced cell, populating a third column in (C) the Target.xls file. Please see example below... Any help would be VERY much appreciated! -Philip

p.s. I also have a freelance VBA project to contract out if a good developer can be located here! Many thanks.

Source.xls

A B C D
1 Big Little Ugly
2 Jack 23 1 300
3 Steve 46 90 5
4 Mary 8 11 0

Target.xls

A B C
1 Big Steve
2 Ugly Mary
3 Little Steve
4 Big Jack
5 Ugly Jack

Desired (after macro):
Target.xls

A B C
1 Big Steve 46
2 Ugly Mary 0
3 Little Steve 90
4 Big Jack 23
5 Ugly Jack 300

Rory - you've done it! In a single line, no less.

Do you know how I would write this into a macro script? (so the source file is automatically referenced without my having to select it?)

Thanks a million.
- Philip

The name of the source file won't change; it is an .xlsx file. The target filename will change, however. So could the source filename be hardcoded? Or when the script is run, excel can prompt the user to select the file? That is what happens when I use the formula you gave me, but I can't use it in a macro - it errors out...

Thanks for getting back to me
- Philip