That helps but what i would like to do is be able to display multiple locations for instance if the value 15 is in column 1 and 2... i do have header row so i could display the value at the top of each column... basically i have programs used on on our production lines and there is a list for Line 1, Line 2, never Run, and 1st time runs. so I want to be able to search that if the program exists any of these locations it will tell me and it could be in several locations