We have used vlookup, find, search, mid, left, right, etc. to search and display a singular cell contents. But can Microsoft Excel 2007 be used to display a list of results?
Attached is an Excel with what we think it would be set out. In this example we have an area where the 'Data' is store, then where the user inters the data to search, finally, the Results display area.
Is this possible? and how can we go about it?