Getting a function to return a reference from different workbook

**mattd30** · 01-29-2009, 10:40 PM

Hello,

I'm trying to get a combination of functions to output a cell reference.

I want to be able to lookup a value from a different workbook and match it to the active workbook to get a reference or location of that value .

For example, the end result would be:

Workbook1:
A
1 Blue
2 Green
3 Red

Workbook2:
A B
1 Green $A$2
2 Red $A$3
3 Blue $A$1

Formulas in workbook 2, column B would find the value A1(Green) in workbook 1 and output the cell reference as it is found in workbook 1.

I just can't seem to get column numbers and references to jive properly and give me the outcome that I need. Please help.

Matt