lookup values on two worksheets

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

I looked at the forums before I posted this question, didn't exactly see my
question:

I have two spreadsheets (e.g. A and B). Both contain instances of the same
data. My data is mainly for Part Numbers and vendors.

SHEET A SHEET B
PN 12345 Nut PN 12345 NUTS R US
PN 65234 Bolt PN 12345 NUTTY BUDDY
PN 65234 BOLTS FOR U
PN 65234 BOLT IT

On sheet A, I have single occurences of my Part number, with a description
of the item. On sheet B, I have one or more occurences of a Part number and
a vendor. I want Sheet A to be able to list all occurences of vendors for
each Part number. Vlookup only returns the first occurence of a vendor. I'd
like to see:

SHEET A
PN 12345 Nut NUTS R US
PN 12345 Nut NUTTY BUDDY
PN 65234 Bolt BOLTS FOR U
PN 65234 Bolt BOLT IT

I'd greatly appreciate any suggestions for how to pick up the additional
vendors from Sheet B. Can this be done?

Thanks,

Dave
 
Insert the vendor column in sheet B, do a VLOOKUP and call that sheet A :-)
 
You must log in or register to reply here.

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

Similar Threads

Show dates if multiple Serail numbers are equal 6
Appending data from two sheets according to like fields 1
Columns to rows 3
Excel Query setup 0
Copy and Fill to another column 5
Excel 2002 VLOOKUP formula or other formula 4
MAX then return value? 10
Prevent combo box autoexpand for new records 3

Back
Top