Formula Help

**Weasel** · 09-13-2006, 11:50 AM

I've got two seperate sheets that I'm working on and I need help with a formula to take pull data from one of the sheets to put in the other. One sheet, my master sheet, has all the unit information for SoHo as well as columns to enter in unit info for LA. The other sheet looks the same except it has all of the LA info. My sheets both look like this:

Please Login or Register  to view this content.

The sheets goes on and on with the different styles, colors, and sizes. What I need is a forumla to put into row H and I that will look in the LA sheet. When it finds the row with the same style, color, and size it will then display the amount of units from the LA sheet for that item. Thanks in advance for any help.

**Excelenator** · 09-13-2006, 02:14 PM

What you want is SUMPRODUCT

Assuming that the columns are laid out as follows:
Column B = Style
Column C = Color
Column D = Size
Column E = Units On Hand
(Adjust the formula below for any differences from these assumptions)

The formula in Column H would be as follows:

Please Login or Register  to view this content.

**Weasel** · 09-13-2006, 02:29 PM

I tried using your forumla but I'm getting an error message. It says the problem with the forumla is the =C5 part. I've got it setup with:

Column B = Style
Column C = Color
Column D = Size
Column E = Units On Hand

Sheet1 named SoHo
Sheet2 named LA

The styles start in row 5 and I'm pasting the forumla in the SoHo sheet in cell G5

**Excelenator** · 09-13-2006, 02:56 PM

Try this since I am assuming the sheets are in the same workbook and you are putting the formula into Soho (Sheet1)?

Please Login or Register  to view this content.

**Weasel** · 09-13-2006, 03:08 PM

Correct, same workbook with a sheet named Soho and another named LA. I'm still getting an error message when I paste the formula and it's pointing towards C5 as the error