Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Variable Lookup/Double Lookup | Excel Worksheet Functions | |||
Join 2 Lists - Lookup value in 1 list & use result in 2nd lookup | Excel Worksheet Functions | |||
Sumproduct - Condition based on lookup of a Lookup | Excel Discussion (Misc queries) | |||
Pivot table doing a lookup without using the lookup function? | Excel Discussion (Misc queries) | |||
How do I lookup and return different values when the lookup value. | Excel Discussion (Misc queries) |