Hi @tatiang & @muneer, you are both correct. I wish for the search to return a result ( a country) from a range of values so that the user will know which country this hexcode belongs to.
@muneer, I am using five columns because of the range conversion into decimal so that the search can be carried out more accurately. This is because in the future I may include the aircraft identities in this app. I have already (thanks to formulae) listed the individual hexcodes across 21 Google Workbooks in preparation for this. Though I am still not sure if I wish to pursue this route. If I did, the search would then return the aircraft’s tail number and consequentially, other details such as airline operator; aircraft type; etc…! but it that will be a huge undertaking for the future.
Andos.