I have two sheets, sheet1 & sheet2. Cell A6 on sheet1 is my input cell. I want to search column C of sheet2 to try and match the text string that is entered in cell A6 on sheet1. If the text string is found on sheet2, I need the row number it was found in returned.
For instance, if I type MICHAEL JORDAN into cell A6 on sheet1, I want the macro to search column C of sheet2 and if it is found on row 44, I want 44 returned to cell A7 on sheet1.
Thanks!
For instance, if I type MICHAEL JORDAN into cell A6 on sheet1, I want the macro to search column C of sheet2 and if it is found on row 44, I want 44 returned to cell A7 on sheet1.
Thanks!