Hi globaltelemetrics and welcome to the forum,
I think the first sheet was making more sense than the new one. With the second I am not even sure where the results would have to go.
Now, if you do want to consider the first sheet you can use this array formula:
***Enter with Ctrl+Shift+Enter key combination
In A7 and drag formula to the right
=INDEX(Data!A$2:A$19,MATCH($A3&$B3&$C3,Data!$A$2:$A$19&Data!$B$2:$B$19,Data!$C$2:$C$19))
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks