Hope somemone can help me. I need excel to look up table values. This look up method is not in the conventional sense. See the attached file for reference. I know the value of A8=1, and I know the value of D8=6, I need excel to find the value of D2. Hlookup and vlookup don't work for this type of applicaton.