I have two workbooks. I need a formula that will: Look for a specific
reference in a selection of cells, check to see if there is a value in
another selectoin of cells that is connected to the first selection, if there
is a value in the second selection, return THAT value into a specific cell.

Something like:
Look at worksheet b, If X = X then look at column n, copy value y from
column n into column z of worksheet a.