You can separate the information with an underscore in the same cell maybe
you can use something else to separate it but this may cause more problems
than it is worth when it comes to looking into the cell when doing the
vlookup. If all of the identifers are the same length of 3 this might make
this an option. Then you can ask it to take everything after the underscore
almost as a seperate value. I dont know where to start with helping to code
that though maybe someone else can help.

HTH Rob