Solved: I am trying to create a calculated column that looks at a couple of different columns - if they match, then display the number, if there's no. Find C18, C8, Phenyl columns and more with the Phenomenex Column Match selection tool. How to use INDEX MATCH to search by row and column values. This formula is an Advantages of INDEX · INDEX & MATCH - formula. I have a lookup value in cell A1. Message 3 of 38 1, Views. Can you tell me if there is something in my formula that causes column match Grieche hittfeld for this article. A10, 0TRUE, FALSE. Now if there are different rates at different times of year I need it to look at the date in Column a on and see what date range it falls between on Per diem Rates and then return the value in the corresponding row in column G.