If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Centralized data
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? |
#2
|
|||
|
|||
Centralized data
And the formula is???
Gord Dibben MS Excel MVP On Thu, 13 May 2010 12:32:01 -0700, Candida 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? |
#3
|
|||
|
|||
Centralized data
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,’FORR EST 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 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? . |
#4
|
|||
|
|||
Centralized data
=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,’FORR EST 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 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? . |
Thread Tools | |
Display Modes | |
|
|