Combine data into central worksheet
 

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?

=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)))

Thank you,

Combine data into central worksheet
 

If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Candida" wrote in message
...
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?

=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)))

Thank you,