I have a series of worksheets with the following format

Fisrtname,Surname,Landline, cellphone, email
John Doe 1234567890 1234567890 [email protected]

I need to creat a search form that lets a user enter firstname or surname or both and it return just the firstname/surname/landline/cellphone in the matching row (or rows if duplicated). If a user enters just the firstname or just the surname it should return firstname/surname/landline/cellphone in the matching row/s Can this be done. I currently have it searching ranges but can only get it to return on one search criteria (eg surname only)