Lookup value and return with all related data

H

help_0616

I have two tabs in one work book
Tab1 looks like this:
work order# (column a)
123
124
128
135
Tab2 looks like this:
column a b c
Porder# vendor name amount
123 Edna $100
123 Susan $200
123 Susan $300
123 Richard $50
156 Becky $250
156 Sussie $100
135 StarCraft $200
128 David $100

I want to pull up all the vendor names and its resptected amount with the
Porder# in tab1 from tab2, eg:
Porder vendorname amount
123 Edna, Susan, Richard $100, $500, $50
156 Becky, Sussie $250, $100
135 StarCraft $200
128 David $100

Would you help me? Thanks for your help in advance!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top