Try this...

=OFFSET('JOB '!$B$20,MATCH('JOB '!$A$38,'JOB '!$B$21:$B$38, 0),1)

Is there really a blank space at the end of that sheet name like your posted
formula shows?

Rick


"SHELL" wrote in message
...
This is an example of the formula I am working on at the moment.
=OFFSET('JOB '!$B$20,MATCH("HD0474",'JOB '!$B$21:$B$38, 0),1)

If I want it to look up the part above (HD0474), but instead of typing it
in
each time, get the information from the field A38 on the same sheet, how
do I
do this?