You have chosen to sponsor your bid up to a maximum amount of .
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.