Two (Relatively) Simply Excel functions needed

IN PROGRESS
Bids
26
Avg Bid (USD)
$36
Project Budget (USD)
$30 - $250

Project Description:
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 required:
Data Processing, Excel
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


Hire nagybatonyi
$ 35
in 0 days
$ 40
in 1 days
$ 30
in 0 days
$ 40
in 5 days
$ 30
in 1 days
Hire manishadk
$ 30
in 1 days
Hire abupabuya
$ 100
in 1 days
Hire rfreelancer2008
$ 40
in 2 days
$ 30
in 0 days
Hire seaanddream
$ 35
in 1 days