HELP! The formulas take duplicates found in two workbooks?

I would like looking at two workbooks in Excel 2010 (formation repairs + Control RE) to double values ​​and makie this. Which formula is there? Note: rich perfectly columns DF catching and both workbooks are identically constructed.



Tab. 1

6 DEF 8 serial number device type repair number 9 0815 xyz 2028



Tab. 2

6 DEF 8 serial number device type repair number 9 0815 xyz 2028

Have you ever thank you for your help. LG Nici :-)

The best answer

To the two tables go. In the top table a VLOOKUP formula from column E deposited

To find a specific value, xl has provided the:

You can choose to "Browse entire workbook" option in search (Ctrl + f) and ausserden option all seek because then all this listed.

Date: 2012-01-31 Views: 0

Related articles

Links

Domicile|Sante|

Copyright (C) 2017 m3tch.com, All Rights Reserved.

M3tch all rights reserved.

processed in 1.489 (s). 10 q(s)