I have one sheet which is an order log and I have one sheet which is a issues
log. I want to set it up that when I enter a customer reference on the
issues log (column F) , it searches the order log and finds the quote number
(column B of order log) and puts that in column E of the issues log, finds
the factory reference number in column I of the order log and puts it in
column G of the issues log.

Is this possible?