Lookup and Compare

  • Thread starter Thread starter DK
  • Start date Start date
D

DK

I have two separate spread sheets with colums that hold
sales data by sku and what % the sku was in stock. One
of the spread sheet shows the first six months of the
year and the second shows the second half of the year.

I am trying to show the two different in stock %'s by sku
on one sheet.

This is how the spread sheets are designed.

Spread Sheet 1 (Jan-Jun)
Column A (sku#) Column B (% in stock)
909837472943 91%

Spread Sheet 2 (Jul-Dec)
Column A (sku#) Column B (% in stock)
909837472943 95%

I am trying to end up with the following results on the
3rd spread sheet

Spread sheet 3 (Jan-Jun) (Jul-Dec)
Column A (sku#) Column B Column C
909837472943 91% 95%

Any help would be appreciated.
 
DK said:
I have two separate spread sheets with colums that hold
sales data by sku and what % the sku was in stock. One
of the spread sheet shows the first six months of the
year and the second shows the second half of the year.

I am trying to show the two different in stock %'s by sku
on one sheet.

This is how the spread sheets are designed.

Spread Sheet 1 (Jan-Jun)
Column A (sku#) Column B (% in stock)
909837472943 91%

Spread Sheet 2 (Jul-Dec)
Column A (sku#) Column B (% in stock)
909837472943 95%

I am trying to end up with the following results on the
3rd spread sheet

Spread sheet 3 (Jan-Jun) (Jul-Dec)
Column A (sku#) Column B Column C
909837472943 91% 95%

Any help would be appreciated.
Click to expand...

Sounds like a great question to ask in an Excel newsgroup - this one is for
MS Outlook. Good luck!
 
My suggestion is that you post to an Excel group, not an Outlook group.
 
Back
Top