Max,

thank you. i will give it a try.

"Max" wrote:

Here's one interp / way ..

Assume this table is in Book1.xls,
in Sheet1, cols A to C, data from row2 down

Field1 Field2 Field3
Text1 Data1 Data11
Text2 Data2 Data12
Text3 Data3 Data13
Text4 Data4 Data14
Text5 Data5 Data15
etc

(Text1, Text2, etc are assumed uniques in col A)

Now, with Book1.xls open,
assume we have this table in Book2.xls,
in Sheet1 (say), cols A to C, data from row2
where we want to populate Fields 2 and 3
according to the items in col A
extracting from the table in Book1.xls

Field1 Field2 Field2
Text2
Text5
Text3
Text4
Text1
etc

Put in B2:

=VLOOKUP($A2,[Book1.xls]Sheet1!$A:$C,COLUMNS($A$1:B1),0)

Copy across to C2, fill down to populate the table

For the sample data above, we'll get:

Field1 Field2 Field3
Text2 Data2 Data12
Text5 Data5 Data15
Text3 Data3 Data13
Text4 Data4 Data14
Text1 Data1 Data11
etc

And perhaps better with an error trap included to return
blanks: "" instead of #NAs for any unmatched items,
we could put instead in B2:

=IF(ISNA(MATCH($A2,[Book1.xls]Sheet1!$A:$A,0)),"",VLOOKUP($A2,[Book1.xls]She
et1!$A:$C,COLUMNS($A$1:B1),0))

Copy across and down to populate the table
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"outlook help" wrote in message
...
I'm trying to compare two values in two different workbooks. Once compared
i
need it to give me the cell address where it's located in workbook 2. Once
i
identify where the value is located, i need to go to that cell address to
populate the cells adjacent to it. Can anyone help me figure out how to do
this, please. Thank you.