Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple V Look up help?
I have a long list.
Column A contains Account Names (many repeated) Column B Contains Orders (many repeated) Column C Contains Invoice Cost. Is it possible to use a vlookup from another worksheet that if detail in Col A & B match then display Column C Detail? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple V Look up help?
It sounds like a Pivot Table would suit your situation.
The layout would be: ROW: Drag the Account Name field here Drag the Orders Fields here DATA: Set this to Sum of Invoice Cost When viewing the Pivot Table, you can click the dropdowns for Account Name and Orders to see only the order details for your selection. Does that help? *********** Regards, Ron "gb_S49" wrote: I have a long list. Column A contains Account Names (many repeated) Column B Contains Orders (many repeated) Column C Contains Invoice Cost. Is it possible to use a vlookup from another worksheet that if detail in Col A & B match then display Column C Detail? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple V Look up help?
i had not thought of that but validating against a list of over 3000 rows, I
was hoping for a quick solution!! Thanks "Ron Coderre" wrote: It sounds like a Pivot Table would suit your situation. The layout would be: ROW: Drag the Account Name field here Drag the Orders Fields here DATA: Set this to Sum of Invoice Cost When viewing the Pivot Table, you can click the dropdowns for Account Name and Orders to see only the order details for your selection. Does that help? *********** Regards, Ron "gb_S49" wrote: I have a long list. Column A contains Account Names (many repeated) Column B Contains Orders (many repeated) Column C Contains Invoice Cost. Is it possible to use a vlookup from another worksheet that if detail in Col A & B match then display Column C Detail? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple V Look up help?
If you are looking for a row with a specific combination of values in A and
B, then you can do what you're wanting by using the CONCATENATION feature, making a helper column to the left of your data and concatenating A and B together into one column, then doing your VLOOKUP on that column...........BUT, VLOOKUP will return only the first instance of whatever it's looking for.........AutoFilter will find all the matches, if it's applicable........... Vaya con Dios, Chuck, CABGx3 "gb_S49" wrote: I have a long list. Column A contains Account Names (many repeated) Column B Contains Orders (many repeated) Column C Contains Invoice Cost. Is it possible to use a vlookup from another worksheet that if detail in Col A & B match then display Column C Detail? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
AHHHH-Get Data from Multiple Excel workbooks | Excel Discussion (Misc queries) | |||
How do i auto create multiple files from 1 with multiple sheets | Excel Worksheet Functions | |||
Adding multiple worksheets | Excel Worksheet Functions | |||
Can I get the mode, min, and max with multiple criteria? | Excel Discussion (Misc queries) | |||
XML / parent with multiple children and with multiple children | Excel Discussion (Misc queries) |