Populate a cell from data matched from 3 other worksheets

**DWAYNE64** · 03-16-2009, 07:36 PM

I was able to use the IF function to match all of the sells in each work sheet but have been unable to figure out how to pull the SYSTEM# from each MASTER into the inventory sheet matching the CCSD row D.

I was able to figure out how to add the IF function to the individual worksheets but I have no idea what function would pull the SYSTEM# from the matching MASTER worksheet.

I'm attaching working document I have so far I was able to use the count function to add up quantities and the conditional format to set up the formats.

Any ideas?

**JBeaucaire** · 03-16-2009, 08:30 PM

Put this MONSTER into D3 on your first sheet and copy it down:

=IF(ISNUMBER(MATCH(C3,MASTER!E:E,0)),INDEX(MASTER!B:B,MATCH(C3,MASTER!E:E,0)),IF(ISNUMBER(MATCH(C3,'MASTER 2'!G:G,0)),INDEX('MASTER 2'!B:B,MATCH(C3,'MASTER 2'!G:G,0)),IF(ISNUMBER(MATCH(C3,'MASTER 3'!J:J,0)),INDEX('MASTER 3'!B:B,MATCH(C3,'MASTER 3'!J:J,0)),"no match")))

**DWAYNE64** · 03-16-2009, 09:11 PM

That did the trick, I would have never figured that one out!

I kept trying to use other functions to pull in the info from other cells, it will be interesting to try and work it on the other larger document, it has about 8 worksheets. If I can get it to link, this will cut my work on the monthly scrub by 3/4!

Now with all the extra time I can actually get my head above water the rest of the week!

Thank you so much!!!

**JBeaucaire** · 03-16-2009, 09:37 PM

You're on Excel 2003, so you're out of luck on the 7th IF statement, that's as deep as it goes. You'll need another approach after that.

**sikki** · 03-17-2009, 09:05 AM

Hi All,

I am aiming to do the same thing, can you look at mine please.

I need to match category and description on the movement sheet and then subtract the total from the Jan stock sheet. I am using excel 2007.

Thanks in advance

Mart

**JBeaucaire** · 03-17-2009, 02:11 PM

Sikki, you really should use other people's threads as source material to try and solve yourself. Post your own question in a thread of its own is the preferred approach.

You need to provide a "starting count" in your January sheet. The February sheet would most likely start with the final stock from January plus any new received stock.

Have a look at this which uses SUMPRODUCT to accomplish your stock control. As you can see, this is nothing like this post/thread at all.