Searching

Hi Howard

Depending on the result you are looking to achieve you may find a vlookup could return the value you are looking for. Alternatively you could use some VBA programming to return the results required. We run a two day VBA course that goes into this topic in detail. Take a look at https://www.stl-training.co.uk/excel-course-in-london-2003-vba.php

I hope this helps.
Kind regards,
Andrew