Search Form

Hi

I have a small project at work which i need some help with please

I have a table that contain Supplier data such as supplier name, suppler code, invoice number , Value etc ( see attachment as an example)

What i want to do is on a different sheet or workbook have a search box whereby the user can either enter a supplier code or invoice number can get the data back. However as an invoice number can be repeated i am not sure how to achieve this...
Any help will be great.

Thanks in advance

Not really the solution i am looking for - i want a user to enter a supplier name in a search box and the data to be populated.
But thanks for your suggestions.