I'm using an 'advanced' VLOOKUP formula (below this paragraph) to let the user find the relevant values based on the input. The user inputs an abbreviation into cell Q10 on sheet 1 which in R10 and downwards a list is then shown giving relevant data from the table that is looked up on sheet 2. (Table on sheet 2 has two columns, an abbreviation and a description column respectively).
It currently shows data results in R10-downwards alphabetically (which I totally understand why, it's meant to), however I would very much like it to sort in order of most relevant. So if there is an exact match to the input then that is shown at the top of the list, and then the list can proceed alphabetically after that. And maybe if an answer has already been given (in the exact match) then it doesn't need to be duplicated in the alphabetical section.
Currently the formula above is just a formula however I can imagine that a macro would be the way forward. Any help would be great!
Code:
{=IF($Q$10=""," No Definitions Available ",IF(ROWS($R$10:R10)>$T$5," No Definitions Available ",INDEX('Acronym Index'!$G:$G,SMALL(IF(ISNUMBER(SEARCH($Q$10,'Acronym Index'!$F$2:$F$10082)),ROW('Acronym Index'!$F$2:$F$10082)),ROWS($R$10:R10)))))}
It currently shows data results in R10-downwards alphabetically (which I totally understand why, it's meant to), however I would very much like it to sort in order of most relevant. So if there is an exact match to the input then that is shown at the top of the list, and then the list can proceed alphabetically after that. And maybe if an answer has already been given (in the exact match) then it doesn't need to be duplicated in the alphabetical section.
Currently the formula above is just a formula however I can imagine that a macro would be the way forward. Any help would be great!