Sort and match two columns without touching a third column...I'm anovice...

[shopthe7]

Hello!
I have an inventory spreadsheet that I need to merge to my product
sheet. My example: I have a product sheet with thousands of products
on it. My supplier does not offer a spreadsheet with inventory on it.
However, I can download a seperate spreadsheet that has the product
number and amount of inventory only. The two spreadsheets do not have
the same amount of rows and the products do not line up- THAT WOULD BE
TOO EASY- SORT DATA....

I need to be able to insert the inventory spreadsheet to the product
spreadsheet and have it match product number to product number and
line up with the inventory available.

Example

Column A: Product code
Column B: Product code
Column C: Inventory level

I need A to match B (B being the constant) so that C does not change-
If the values do not match it should remain blank.

Can anyone give my direction on this?

Thanks!

 

[Art]

This may not be what you're looking for, since I'm only using 2 columns on my
product sheet. For simplicity, assume that the inventory is in A1:B5 on
Sheet1.
There are 10 products in A1:A10 on Sheet2.

Put this formula in Cell B1 on Sheet2.

=IF(ISNA(VLOOKUP(A1,Sheet1!$A$1:$B$50,2,FALSE)),"",VLOOKUP(A1,Sheet1!$A$1:$B$50,2,FALSE))

Then copy it down to the other rows A2:A9.

This will give you a blank if you have a product that doesn't appear in the
inventory.

 

[shopthe7]

This may not be what you're looking for, since I'm only using 2 columns on my
product sheet.  For simplicity, assume that the inventory is in A1:B5 on
Sheet1.
There are 10 products in A1:A10 on Sheet2.

Put this formula in Cell B1 on Sheet2.

=IF(ISNA(VLOOKUP(A1,Sheet1!$A$1:$B$50,2,FALSE)),"",VLOOKUP(A1,Sheet1!$A$1:$­B$50,2,FALSE))

Then copy it down to the other rows A2:A9.

This will give you a blank if you have a product that doesn't appear in the
inventory.









- Show quoted text -

Well,

I'm not sure what that was supposed to do, but it didn't do anything
and I received an error message. Here's another approach: If I copied
Product codes into Column A, Product codes into Cloumn B, and
Inventory levels into Column C- Is there a way to match column A to B
and leave a blank if the do not match?

Example:

Before Sort/Match

A B C
1 2 130
6 1 150

After Sort/Match

A B C
1 1 150
6
2 130

I appreciate your help and your quick reply!

William

 

[shopthe7]

Well,

I'm not sure what that was supposed to do, but it didn't do anything
and I received an error message. Here's another approach: If I copied
Product codes into Column A, Product codes into Cloumn B, and
Inventory levels into Column C- Is there a way to match column A to B
and leave a blank if the do not match?

Example:

Before Sort/Match

    A    B    C
    1     2   130
    6     1   150

After Sort/Match

    A    B    C
    1     1   150
    6
           2   130

I appreciate your help and your quick reply!

William- Hide quoted text -

- Show quoted text -

I got it!!!! I found my answer (in detail) here
http://www.ehow.com/how_4668602_lookup-data-excel-vlookup.html