In Progress

Excel Lookup Function

We need the code for an Excel Lookup Function to reference color codes on another database file. Example - the current field on File 1 has the values, “white”, “black”, “red”, etc. We want to be able to run the function so that these color codes lookup File 2 and output the corresponding numeric color codes (i.e. “10”, “20”, “30”, etc) to a separate field in File 1 . We need the output to be on one line, separated by commas, in one field.

We would also like the function to be able to lookup and output sizes from another file, similar to the above.

Skills: Data Entry, Data Processing, Excel

See more: red black data, black& red, numeric, LOOkup, function, excel function, code function, color code reference, codes excel, excel code database, excel line, lookup excel, database output code, code database excel, Excel code, data entry code excel, separate excel, black white red, excel pdf separate worksheets, similar function, red circle line, output data excel, function font color, excel output, excel generate separate graph individual

About the Employer:
( 1 review ) Chelmsford, United States

Project ID: #1263980

Awarded to:

nagybatonyi

If you send me the 2 files, I'll make a draft. Regards!

$45 USD in 1 day
(39 Reviews)
5.4

39 freelancers are bidding on average $64 for this job

SigmaVisual

We can help in your project, please check PMB and our ratings/reviews to get idea of our experience.

$50 USD in 1 day
(30 Reviews)
5.8
vserv

I specialize in Excel. Thanks

$50 USD in 1 day
(59 Reviews)
5.7
danielgpratidya

I'm done with your project, see your pm

$250 USD in 0 days
(70 Reviews)
5.5
vbexcel

Excel macro expert - ten years experience.

$50 USD in 1 day
(25 Reviews)
5.3
binaryromel

##### Excel expert here! Please check PM. #####

$30 USD in 1 day
(45 Reviews)
5.2
MDavidCrompton

Please see feedback on recent Excel Projects. I can do this today, Wed, in just a few hours. See example. Named colours by function or actual colors by macro. David

$30 USD in 1 day
(23 Reviews)
4.9
dev3dworx

Please check PMB for details.

$50 USD in 1 day
(19 Reviews)
4.7
DrTech76

Hi!

$30 USD in 0 days
(26 Reviews)
4.6
psprongs

Hi, I have good deal of experience in data processing using excel. I can start immediately. Please check PMB psprongs

$30 USD in 0 days
(9 Reviews)
4.2
microk

Excel Whiz here.. See attached sample in PM. MicroK

$30 USD in 1 day
(20 Reviews)
4.1
shacoim

***Plz Check PM***

$30 USD in 0 days
(13 Reviews)
4.0
ExactSystems

Please see bid detail on PMB. regards

$100 USD in 3 days
(3 Reviews)
3.8
JackBradford

Hello, Please see the PMB for details.

$200 USD in 1 day
(7 Reviews)
3.5
vgrichards

Very Good at Excel 2003-2010 and Excel VBA Macros. Please allow me to do it. Will ensure everything is as per your requirement.

$30 USD in 1 day
(16 Reviews)
3.5
counterpuncher

Hi, I find your project offer very interesting and challenging and I want to work on it. I have experiences in manipulating data in excel using different excel functions, one of which is the lookup. There are als More

$40 USD in 2 days
(9 Reviews)
3.4
habayabah

Please read my PM for details of my bid.

$30 USD in 0 days
(3 Reviews)
3.1
monica365

Hi, I have experience working with formulas in Excel. Thanks

$30 USD in 1 day
(5 Reviews)
3.0
FirestarterXIII

I can make it in 2-3 hours. Fast and cheap.

$30 USD in 1 day
(1 Review)
2.4
guevanjr

Please consider my bid. Thanks.

$40 USD in 1 day
(3 Reviews)
2.2
webexpertkunal

We are new in freelancer but we are 5 years experienced data entry [url removed, login to view] are sincerely read your requirements and are ready to endow with the solution as per your requirement.Thanks.

$200 USD in 7 days
(1 Review)
1.5