Relatively Simple Excel function help needed

Need help coming up with an Excel function. This one should be quite simple and straightforward if you have sufficient experience with Excel functions (which I don't). What I'm looking for is a function for the cells in a column (Column A) that, for each row, will compare the value in Column B for that 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. If a match is found, the corresponding value in Column A of that row will then be returned. If no match is found, the text 'NO MATCH' will be returned.