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
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.
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.
Related:
- Looking for formula.
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Number to words in excel formula - Guide
- Credit summation formula - Guide
- Excel grade formula - Guide
- Date formula in excel dd/mm/yyyy - Guide
1 response
Zohaib R
Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
69
Apr 23, 2013 at 11:32 PM
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.
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.
