Ive used Access to search a table and display results on a form but can this
be done in excel? For example, I want the end user to be able to enter "first
name" into a text box, and "Surname" into another. I want the rows in excel
to be searched and if they match the input to display that row in another
form.

Is this possible?