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,’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)))

Thank you,

      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
dguillett@gmail.com
"Candida" <Candida@discussions.microsoft.com> wrote in message 
news:74A27565-8B03-41E1-802F-46B44B719D17@microsoft.com...
>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,’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)))
>
> Thank you,