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?