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?
|