Two (Relatively) Simply Excel functions needed

In Progress

Need help tweaking an Excel function to work with spreadsheet and coming up with an additional Excel function for same spreadsheet. This one should be quite simple and straightforward if you have sufficient experience with Excel functions (which I don't).

For the first function, I'm looking for a function that will compare the value in Column B for a row with all the values in the same column for the rows above as well as all the rows in that column (Column B) in two other worksheets and that will copy to Column A the contents of Column A for any match found.

For the second function, if the value in Column K matches a value in Column K on a different spreadsheet, the results will be copied to Columns M, P and Q.

Can send over sample spreadsheet to help explain things better.

Skills: Data Processing, Excel

See more: simply well, excel help needed, need help excel, excel compare two worksheets, excel function, compare spreadsheet, relatively simple function, excel row column, compare rows excel, excel additional, excel compare columns data, additional functions, excel column row, excel compare row, simply data excel, column row excel, excel match columns row, excel column copy, excel copy values, excel compare columns, excel data match, match columns excel, functions spreadsheet, sample data processing spreadsheet, excel column column

Project ID: #4287859

Awarded to:

sasindiv

Hi, I have 8 years experience in programming. I have sent personal message to you with the detailed solution.

$30 USD in 2 days
(1 Review)
1.2

26 freelancers are bidding on average $36 for this job

nagybatonyi

See your formulas in PMB! Regards

$35 USD in 0 days
(38 Reviews)
5.3
vbexcel

Excel pro, I can start on your project today.

$40 USD in 1 day
(25 Reviews)
5.2
ethicalboy

Thanks foe this project.

$30 USD in 0 days
(26 Reviews)
4.7
jal540

I have done many custom Excel projects and have excellent ratings.

$40 USD in 5 days
(8 Reviews)
4.1
mandeeps207

Hi there, Its me pleasure to finish this task for you. If interested pls reply asap..... regards

$30 USD in 1 day
(17 Reviews)
3.9
manishadk

I am Expert in Excel. Please check PMB for details.

$30 USD in 1 day
(8 Reviews)
3.5
abupabuya

//////////////SELL ITEMS////////////////

$100 USD in 1 day
(4 Reviews)
3.4
rfreelancer2008

Hi there - I am ready to start this asap, and am very much interested to work on this project with you. I am passionate to work on VBA projects and would like to get a chance to work on this one. more in pmb.

$40 USD in 2 days
(9 Reviews)
3.1
jaylancer43

Please check your PM..!!

$30 USD in 0 days
(6 Reviews)
2.9
seaanddream

very much inetersted with your project with excel functions... KR,

$35 USD in 1 day
(5 Reviews)
2.8
benefitworks

This is very easy. I can finish in few hours. Thanks karim

$30 USD in 1 day
(3 Reviews)
2.5
saravanan87

I am ready to start.. Please post the both excel sheet...

$30 USD in 1 day
(1 Review)
1.6
suriyant

With more than 10 years experience in Excel and VBA programming, I can do it immediately.

$30 USD in 0 days
(1 Review)
1.0
ranjanappa

Hi I am a MIS analyst making excel reporting from past 8 years i am very good with excel formulation and automation. i am interested in this project it sounds very interesting to me. i can work with accuracy and i have More

$30 USD in 1 day
(1 Review)
0.0
florinfota

I have the necessary skills to do this job - more than 20 years of experience in MSOffice

$30 USD in 2 days
(0 Reviews)
0.0
shofi39

Dear Sir, I am well versed in accounting as well as excel and Quickbooks. Please consider me. Hope to hear from you soon. Shafikul Islam

$50 USD in 4 days
(0 Reviews)
0.0
Iul1a

Hi Sir! I would kindly appreciate it if this opportunity were given to me. Thank you. Iulia

$32 USD in 2 days
(0 Reviews)
0.0
yogasvara

That's what I do 5 years ago. Just give me your sample data and you will be smile.

$35 USD in 1 day
(0 Reviews)
0.0
MCH2000

Hello, ready to start.

$40 USD in 1 day
(0 Reviews)
0.0
sylvestermolina

Consider it done :D Ready to go.

$30 USD in 0 days
(0 Reviews)
0.0