Vehicle Spec Search 1b.xls

Hi sktneer,
Many thanks for your response.
I reverted back to the original worksheet and added the formula (attached with extra data); I have a few issues to address..

On occasions there will be multiple results to be displayed (the formula will only return one result)

I need the search to work on strings so if I entered "A3" in the Model field the entry "A3 sport" would be displayed as well as "A3"

If I only enter "audi" into the make field and leave Model & Year fields empty I would like all "Audi" records to be displayed

Hope that makes sense.