excel VBA to find correct formula to get result from hexcode : I have some missing data where I need to workout the formula used to convert a code to a hex file and vice versa. The codes below are some examples of a complete set , I was trying to find a way to get the result from column A to column B , when that is found then compare it with row 2 if that is okay then row 3. when all criteria are matched then provide the formula used. Examples are below

    A00875	101AK
    A00F82	1027U
    A01040	103EC
    A01829	105KA
    A01DD2	1063U

