hi looking for a formula to combine two worksheets in one both have 3 columns.
if i copy the both worksheet in one than i have 6 columns like this.
A ---------B --------C----------- D -----------E--------------F------------G
ireland----353-------0.34 ------1.66----------india--------- 92---------3.67
germany--12--------2.33 -------2.78---------USA-----------01--------- 0.75
india-------92-------1.23-----------------------UK------------44----------1.98
usa-------- 1 -------0.25-----------------------GERMANY-----12----------2.78 (delete)
uk ---------44-------3.23----------------------ireland---------353---------1.66 (delete)
FORMULA: It should match the two value in columns A (ireland) & B(353) with values in column E(ireland) & F(353)........than write the value of G(0.75) in Column D in front of IRELANF in column A......and delete the value 1.66 from G column.
You can find the matching values from the other table/worksheet using Microsoft Excel's VLOOKUP() Worksheet Function. For example to find the matching value for "ireland" and put it in the D1 use the below mentioned formula in D1:
=VLOOKUP(A1,$E$1:$G$5,3,0)
To delete a value you might need to use a Macro.
Please reply if you need any further clarification.
