Thanks Gary but it doesn't seem to work still. It gives me data from column I
but seems to give a random row rather than the cell directly to the left of
the cell in J

"Gary''s Student" wrote:

=INDIRECT("I" & MATCH(B7,J1:J32,1))
--
Gary''s Student - gsnu200725