Best way to derive values in cross reference file

Hi, I have a requirement where I need to derive a value from cross reference file.(* means any value) Ex: Cross reference file data A B C D 1 * 12 2222 2 a 22 1111 3 b * ...