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.
26 freelancers are bidding on average $36 for this job
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.