Quote Originally Posted by Excel Fox View Post
You mean to say that the value in Q4 may be in any cell in the range A4:F100?
It is in fact at any place in column "A", but once it's found I need to use the value in "F" of the same row it was found in.