Hi guys,

I would like to have match code that can find row number match 2 criteria from my 2 textboxes. Is there a way other than to autofilter the sheet or to loop find? My records are quite huge.

For example, I have 2 textboxes to put in Name and surname. I want the code to find the row number that match exactly name and surname in the table below:

No. Name Surname Tel
1 aaa zzz 1234567
2 bbb yyy 2345678
3 ccc xxx 3456789
4 bbb www 4567123