H/V Lookup
 

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?

H/V Lookup
 

You would need two VLOOKUP formulas. Assuming column A of your Order Log is
the Customer Reference, and that both sheets have Row 1 as headers,
Put this in E2 of the Issues Log sheet and copy down as necessary...

=VLOOKUP(F2,'Order Log'!A:I,2,FALSE)

Then, put this one in G2 of the Issues Log sheet and copy down as necessary...

=VLOOKUP(F2,'Order Log'!A:I,9,FALSE)

Vaya con Dios,
Chuck, CABGx3


"singingsister" wrote:

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?