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? |
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? |
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? . |
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? . |
All times are GMT +1. The time now is 07:05 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com