Hi Greetings, I want to match a reference cell with 3 different cells and return if matched by any of the 3 cells. Eg: Condition 1: A5 is the reference cell, if A5 = B5 then it should return "On track" Condition 2: If A5<>B5 , it should take reference cell as B5 and look up for the match below A5. i.e., A4,A3,A2,A1. If any one of the cell matches with B5 , it should return "slow" Condition 3:If A5<>B5 , it should take reference cell as B5 and look up for the match above A5. i.e., A6,A7,A8,A9. If any one of the cell matches with B5, it should return "Fast" Either through formula or VB Script
Solved by F. Y. in 26 mins