Looking for formula.

[Closed]
Report
Posts
4
Registration date
Tuesday April 23, 2013
Status
Member
Last seen
October 31, 2013
-
Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
-
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.

1 reply

Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
46
Hi ahamaz,

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.