Centralized data
in [General]
|
From: Candida on 13 May 2010 15:32 I have a main costing work sheet that needs to be populated by individual costing sheets that went out to all of the buyers to populate. Main Costing Sheet A. Item # B.Desc C. QTY D. Cost E.....F.........G......H (all contain irrelevant information to costing activity. There are 5 buyers (Nick, Tanya, Doug, Skip and Forrest) that I have divided up the main costing sheet and sent them thier individual items to cost, now that I am getting the individual costs back, I need to populate my "Main Costing Sheet" with each cost, however, the items are all together and not separated on this sheet. I created the following Vlookup and keep getting error messages. Can someone please help me fix this formula or figure out an easier way to take the costs off of each individual sheet and populate my Main Costing Sheet?
From: Gord Dibben on 13 May 2010 19:05 And the formula is??? Gord Dibben MS Excel MVP On Thu, 13 May 2010 12:32:01 -0700, Candida <Candida(a)discussions.microsoft.com> wrote: >I have a main costing work sheet that needs to be populated by individual >costing sheets that went out to all of the buyers to populate. > >Main Costing Sheet >A. Item # B.Desc C. QTY D. Cost E.....F.........G......H (all >contain irrelevant information to costing activity. > >There are 5 buyers (Nick, Tanya, Doug, Skip and Forrest) that I have divided >up the main costing sheet and sent them thier individual items to cost, now >that I am getting the individual costs back, I need to populate my "Main >Costing Sheet" with each cost, however, the items are all together and not >separated on this sheet. I created the following Vlookup and keep getting >error messages. Can someone please help me fix this formula or figure out an >easier way to take the costs off of each individual sheet and populate my >Main Costing Sheet?
From: Candida on 17 May 2010 16:40 The formula is as follows: =IF(ISNA(VLOOKUP(B2,'Tonya''s response'!A$2:P$264,12,FALSE)),VLOOKUP(B2,'Nick Costing''!A$2:P$160,12,FALSE),IF(ISNA(VLOOKUP(B2,'Nick Costing'!A$2:P$160,12,FALSE)), VLOOKUP(B2,'Skip Costing'!A$2:P$160,12,false),IF(ISNA(VLOOKUP(B2,'Skip Costing'!A$2:P$160,12,FALSE)),VLOOKUP(B2,'Doug Costing', A$2:P$299,12,FALSE),IF(ISNA(VLOOKUP(B2,'Doug Costing'!A$2:P$160,12,FALSE)),VLOOKUP(A2,'FORREST Costing'!A$2:P$160,12,FALSE)),IF(ISNA(VLOOKUP(B2, 'FORREST Costing'!A$2:P$160,12,FALSE)),VLOOKUP(B2,'Tonya''s response'!A$2:P$264,12,FALSE))) "Gord Dibben" wrote: > And the formula is??? > > > Gord Dibben MS Excel MVP > > On Thu, 13 May 2010 12:32:01 -0700, Candida > <Candida(a)discussions.microsoft.com> wrote: > > >I have a main costing work sheet that needs to be populated by individual > >costing sheets that went out to all of the buyers to populate. > > > >Main Costing Sheet > >A. Item # B.Desc C. QTY D. Cost E.....F.........G......H (all > >contain irrelevant information to costing activity. > > > >There are 5 buyers (Nick, Tanya, Doug, Skip and Forrest) that I have divided > >up the main costing sheet and sent them thier individual items to cost, now > >that I am getting the individual costs back, I need to populate my "Main > >Costing Sheet" with each cost, however, the items are all together and not > >separated on this sheet. I created the following Vlookup and keep getting > >error messages. Can someone please help me fix this formula or figure out an > >easier way to take the costs off of each individual sheet and populate my > >Main Costing Sheet? > > . >
From: Candida on 17 May 2010 17:30 =IF(ISNA(VLOOKUP(B2,'Tonya''s response'!A$2:P$264,12,FALSE)),VLOOKUP(B2,'Nick Costing''!A$2:P$160,12,FALSE),IF(ISNA(VLOOKUP(B2,'Nick Costing'!A$2:P$160,12,FALSE)), VLOOKUP(B2,'Skip Costing'!A$2:P$160,12,false),IF(ISNA(VLOOKUP(B2,'Skip Costing'!A$2:P$160,12,FALSE)),VLOOKUP(B2,'Doug Costing', A$2:P$299,12,FALSE),IF(ISNA(VLOOKUP(B2,'Doug Costing'!A$2:P$160,12,FALSE)),VLOOKUP(A2,'FORREST Costing'!A$2:P$160,12,FALSE)),IF(ISNA(VLOOKUP(B2, 'FORREST Costing'!A$2:P$160,12,FALSE)),VLOOKUP(B2,'Tonya''s response'!A$2:P$264,12,FALSE))) "Gord Dibben" wrote: > And the formula is??? > > > Gord Dibben MS Excel MVP > > On Thu, 13 May 2010 12:32:01 -0700, Candida > <Candida(a)discussions.microsoft.com> wrote: > > >I have a main costing work sheet that needs to be populated by individual > >costing sheets that went out to all of the buyers to populate. > > > >Main Costing Sheet > >A. Item # B.Desc C. QTY D. Cost E.....F.........G......H (all > >contain irrelevant information to costing activity. > > > >There are 5 buyers (Nick, Tanya, Doug, Skip and Forrest) that I have divided > >up the main costing sheet and sent them thier individual items to cost, now > >that I am getting the individual costs back, I need to populate my "Main > >Costing Sheet" with each cost, however, the items are all together and not > >separated on this sheet. I created the following Vlookup and keep getting > >error messages. Can someone please help me fix this formula or figure out an > >easier way to take the costs off of each individual sheet and populate my > >Main Costing Sheet? > > . >
|
Pages: 1 Prev: Summing 2 columns cells into a 3rd colums cells Next: alphabetize worksheet names |