I also would like to do the same process but for a different button. Sheet1 cell B5 would be more of a search field, so it could pull the answer that best matches the most words. Example: in B5, a person would type- "can't get machine to start up", now the code will search sheet2 A1 thru A100 and the msg box will pop up with which ever msg has the most matched words from the sheet1 B3 cell. (If sheet2 A72 had "machine start up failure, hit reset" then that would most likely populate in the msgbox.