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?

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?

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?

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?