 You don't need to be an 'investor' to invest in Singletrack: 6 days left: 95% of target - Find out more
Morning,
I have one sheet which contains details of 300 documents e.g document number and title.
I'd like to have another sheet or a section at the top of that first sheet in which one could enter part of the document number and title and it would return multiple possible matches which include the details in their respective rows in the original sheet.
The people accessing this might not know how to do filters or simple search so I'm trying to replicate a search engine facility which returns possible matches if they're unsure of ref number or full title.
Would vlookup do the trick?
Thanks again.
=MATCH will get you the answer but you need the full string, not a partial one.
Alternatively, you could add all the documents strings to a dropdown box (combo box) and then the user could pick one.
I'm halfway there but don't have time to do the tidying up.
=IF(ISNUMBER(SEARCH($B$1,A1)),CELL("address",A1),"")
where $B$1 = your search string
A1 = first row in the list of titles
this will return the cell reference of A1 if it contains the search string. You could change "address" to "contents" and it will return the document title instead.
Copy the formula down for as many documents you have and then use some kind of "blank cell" removing formula in the next column to tidy up the list.
I'm sure there'll be a way of entering an array formula that will give you a list of the references of all cells that contain the search string all nice and tidy but I have kids to look after at the moment.
Thank you both on a Saturday morning. I'll try these on Monday. Cheers.
PMd you, OP