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?