Previous Topic Next Topic

Looking for formula.

Closed
ahamaz Posts 4 Registration date Tuesday April 23, 2013 Status Member Last seen October 31, 2013 - Apr 23, 2013 at 07:59 PM
Zohaib R Posts 2368 Registration date Sunday September 23, 2012 Status Member Last seen December 13, 2018 - Apr 23, 2013 at 11:32 PM
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

Answer 1 / 1
Zohaib R Posts 2368 Registration date Sunday September 23, 2012 Status Member Last seen December 13, 2018 67
Apr 23, 2013 at 11:32 PM
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.
0