Finding matching cells between two workborks and updating cell con
 

Hi,

I have two workbooks, I would like to replace information in the first
workbook with information from the second book by searching for a reference
and then replacing information.
Workbooks contain following info -
Operation number - EA100, Operation time 0.30.
I want to find the operation number and then replace the operation time with
the latest time from the second work book.

Thanks in advance

Finding matching cells between two workborks and updating cell con
 

Assume source Ops Nos & Ops Times are
runnning in A2 and B2 down in Sheet1 in Book1.xls

With Book1.xls open simultaneously,
In Book2.xls, in Sheet1,
Assuming Ops Nos running in A2 down
place in B2:
=INDEX([Book1]Sheet1!$B:$B,MATCH(A3,[Book1]Sheet1!$A:$A,0))
Copy down

Perhaps better with an error trap to return blanks: "" instead of ugly
#N/As, you could use instead in B2:
=IF(ISNA(MATCH(A3,[Book1]Sheet1!$A:$A,0)),"",INDEX([Book1]Sheet1!$B:$B,MATCH(A3,[Book1]Sheet1!$A:$A,0)))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"tukky142" wrote:
Hi,

I have two workbooks, I would like to replace information in the first
workbook with information from the second book by searching for a reference
and then replacing information.
Workbooks contain following info -
Operation number - EA100, Operation time 0.30.
I want to find the operation number and then replace the operation time with
the latest time from the second work book.

Thanks in advance

Finding matching cells between two workborks and updating cell
 

Sorry, correction for consistency with formulas suggested earlier which were
for B3 instead of B2:

In Book2.xls, in Sheet1,
Assuming Ops Nos running in A2 down
place in B2:

A2, B2 in the lines above should read as A3, B3
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---