Search row number match 2 textboxes criteria

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

I would have a new column that combines the first and last names, do the same in your reference data and then vlookup or match on this new column.

Fullname = Name & " " & Surname

Assuming Name in Col.B, Surname in Col.C and get No in col.A

Please Login or Register  to view this content.

Hi Jindon,
Thank you so much for your help. This code work great!

I want to ask a bit more about your code. If I want to set b1:b10000&c1:c10000
as a dynamic range e.g. to the last row based on column A, how to write the code for that?

Hi kersplash
Thanks for the idea. I will keep the suggestion for future.
Based on this case, the records I have are quite dynamic so I dont want to concat them everytime my records are changed.

Originally Posted by impresxy

I want to ask a bit more about your code. If I want to set b1:b10000&c1:c10000
as a dynamic range e.g. to the last row based on column A, how to write the code for that?

OOps missed this post
It would be like

Please Login or Register  to view this content.

Jindon,

Thank you so much