| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Increase Your Business By Data Conversion, Data Format and Data EntryServices in India | Excel Worksheet Functions | |||
| Save 20% On Data Conversion and Data Formats Services by Data EntryIndia | Excel Discussion (Misc queries) | |||
| Data Entry Online, Data Format, Data Conversion and Data EntryServices through Data Entry Outsourcing | Excel Discussion (Misc queries) | |||
| Multiple worksheets, Centralized Formula Repository | Excel Discussion (Misc queries) | |||
| MULTIPLE DATA - How to insert new data into existing data.... | Excel Discussion (Misc queries) | |||
Linear Mode
