Is it possible to write an "If/Then" procedure that evaluates if a give
cell value is equal to any cell value within a range of cells the
return the value of another cell in the same row as the equalled cell
e.g.
For n = 1 to 16
If Cells(n, "A").Value = The value of any cell between (n + 18. "A"
and (n + 50, "A) Then
Cells(n, "B").Value = (Equaled N + row, "B").Value

Looks like it should be doable but I can'T

--
knowtrum
-----------------------------------------------------------------------
knowtrump's Profile: http://www.excelforum.com/member.php...fo&userid=1966
View this thread: http://www.excelforum.com/showthread.php?threadid=51416