Quote Originally Posted by xld
ARe you looking for something that will find say M17 where you have data in A7, B8 and M17, and headings in A1:P1
Yes Bob, exactly that! is it possible? what am i saying?, the fact that you answered and asked that question says it is!, if a cell has a formula but not returning a value so effectively blank would it return that or ignore it?