Finding the ROW

[Pauljj]

Can someone let me know if this is possible please

I want to return the row number if, when someone type in a name in cell B2 it looks for the name in column A, if it finds it, it returns the row number, it shouldnt be case sensitive and also would need to be able to find the text within text, within the cell


Hope that makes sense


Cheers

Paul

 

[barry houdini]

You could try

=MATCH("*"&B2&"*",A:A,0)