I am using this " =LOOKUP($N$2,$A$6:$A$3207,$H$6:$H$3207) " to search for a value,
sometimes range a6:a3207 has more than one cell that meets the criteria.
Is there a way to offer a choice of which cell to use. eg
I am looking for post code 3011 in a6:a3207, there are 3 instances in the column. Footscray, Seddon and Seddon East,
h6:h3207 displays the search result as Seddon East, simply because its the last one of the 3 choices.
Any way to give the user the ability to select which one of the 3 displays ??
Thanks
Ian
Bookmarks