MSGROUPS.NET | Search | Post Question | Groups | Stream | About | Register

### Combine data into central worksheet

• Follow

```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
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,
```
 0

```      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
> 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,

```
 0

1 Replies
191 Views

Similiar Articles:

7/15/2012 3:47:49 PM