Updating Records /Deleting non-duplicate data?

**Ryguy786** · 12-17-2012, 04:25 PM

Hi there.
I'll keep it short.
I'm updating inventory records.

I get an excel sheet from a Vendor that says product name in column A "XYZ". and Column B that Gives a date for availability for that product.

So I pasted their columns A and B next to my column A (Product name) to product this

A----B---C
AB1----AB1----12/1
AB2----AB2-----12/1
AL54.....AB55.......12/2
AL57......AL50.......12/3
AL99......AL54......12/7

Is there an easy to sort Column B+Their relative Column C up with my column duplicate matches? And the extra somehow just delete the extras that I don't carry?

I'd need the above to look like this

A----B---C
AB1----AB1----12/1
AB2----AB2-----12/1
AL54.....AL54......12/7
etc...

Hope I'm not being confusing....

**Moo the Dog** · 12-17-2012, 04:36 PM

It would be better if you pasted the vendor's data on a second sheet in columns A and B. Then on your original sheet with your products in column A, you can use a VLOOKUP formula to retrieve just the products that you carry like so:

in column B2 on your original sheet, next to your first product (lets just assume your first product is in cell A2), try this:

=VLOOKUP($A2,Sheet2!$A:$B,1,0)

Then in cell C2 on your original sheet you can use:

=VLOOKUP($A2,Sheet2!$A:$B,2,0)

- Moo

**Ryguy786** · 12-17-2012, 05:09 PM

Hi

Thank you - I see how that works now

I appreciate it! You've been a great help!

**Moo the Dog** · 12-17-2012, 05:14 PM

Glad to help.

- Moo

--------------------
If my solution has helped, feel free to leave feedback by clicking on the star on the lower-left corner in one of my posts. It's always appreciated.