Færdiggjort

EXCEL / Duplicate Lines based on lookup matches

I have an Excel worksheet of 4358 record entries. Each entry has a unique combination of values in column A and B (combined they make up the current key) and a blank column C for the third field in the key. For example:

WORKSHEET 1

Key 1 | Key 2 | Key 3

120 | 3 |

120 | 5 |

167 | 3 |

167 | 7 |

167 | 9 |

198 | 2 |

A second worksheet lists the possible values for Key 3 (look up based on Key 1)

WORKSHEET 2

Key 1 | Possible A | Possible B

120 | | 2596394

120 | | 2403020

167 | A200 |

198 | |

For each 'Key 1' value there will be 1 match with a value in 'Posssible A' OR multiple matches with values in 'Possible B' OR no matches at all.

If there is 1 match with a value in 'Possible A' (see 167 above), simply populate 'Key 3' with the value from 'Possible A'

WORKSHEET 1

Key 1 | Key 2 | Key 3

167 | 3 | A200

167 | 7 | A200

167 | 9 | A200

If there are multiple matches with values in 'Possible B' repeat each record for each unique value

WORKSHEET 1

Key 1 | Key 2 | Key 3

120 | 3 | 2596394

120 | 3 | 2403020

120 | 5 | 2596394

120 | 5 | 2403020

If there are not matches, simply return the record unadjusted

WORKSHEET 1

Key 1 | Key 2 | Key 3

198 | 2 |

All scripting must be done within Excel and be reusable. I think I would like to have a button to click that will create a new worksheet and print the results to the new worksheet leaving the original worksheets untouched.

Actual data will be given to the winning bidder. Need finished ASAP (next 16 hours)!!

Færdigheder: Dataindførsel, Excel, Visual Basic

Se mere: duplicate data entry, new excel, reusable, LOOkup, excel duplicate, excel based, excel 7, create excel worksheet, multiple excel, data entry worksheet excel, excel unique, excel record, excel excel 2010, record excel, simply data excel, excel column unique value, excel populate worksheet worksheet, record lookup, multiple value lookup excel, excel duplicate values, results asap, excel create, excel combination, asap results, excel data match

Om arbejdsgiveren:
( 15 bedømmelser ) College Station, United States

Projekt-ID: #826520

Tildelt til:

best4best

I am an Excel expert and can complete the job in a few hours from now.

$30 USD in 0 dage
(125 bedømmelser)
5.8

9 freelancers are bidding on average $62 for this job

SouthIndian

I can finish this in couple of hours.

$30 USD in 0 dage
(138 bedømmelser)
5.8
FlashBack

Please view the PMB

$150 USD på 1 dag
(13 bedømmelser)
3.9
ankurb43

Please see PM

$50 USD på 1 dag
(1 bedømmelse)
2.8
Kubwaj

Hi there....i can do this and submit with in the time frame will required testing..

$150 USD in 0 dage
(4 bedømmelser)
2.7
absrads

Hi, Please refer to your PMB. Thanks.

$60 USD in 0 dage
(1 bedømmelse)
1.2
salientcomputer

Hi Please see PMB.

$30 USD in 0 dage
(1 bedømmelse)
1.0
elmerM

Good Day sir! I can do it immediately sir.. Please see PM. Hoping, EM

$30 USD på 1 dag
(0 bedømmelser)
0.0
lookinfo

Hello sir/madam, Please check pm.

$30 USD på 1 dag
(0 bedømmelser)
0.0