Unifying two lists with different lengths 1

[BrCo]

Hello everyone,
I would appreciate your help.
I have two specimen lists, with different lengths, and I wish to unify them (it is difficult to explain, so I attached an Excel file to show what I mean).
Many thanks in advance!
BrCo

 

[GregLocock]

Um. Very hard to detect your logic thar, bucko.

Cheers

Greg Locock


New here? Try reading these, they might help FAQ731-376

http://eng-tips.com/market.cfm?

 

[magoo2]

Yes I'm afraid the worksheet is equally unclear as your posting.

 

[BrCo]

Sorry about that, I'll try to explain myself better.
I am doing a survey, counting how many specimens of each species are living in each sub-sample. There are 2 lists: the overall list (rows 3 and 4), and the sub-sample list (rows 6 and 7). The overall list includes all the potential species, but the sub-sample list does not necessarily include all of them (that is, some species are not present in the sub-sample). What I want is to put each specimen count of the sub-sample (row 7) in its proper place in row 4. For example, the content of cell B3 equals the content of cell B6, therefore the content of cell B7 needs to be copied to cell B4. Cell D3, however, does not match any cell in row 6, therefore cell D4 should get the value 0 (zero).
It may seem trivial, but in reality I have about 2000 species and 200 different sub-samples, so any help you can give will be most appreciated!

 

[GregLocock]

Easy peasy. See attached

Cheers

Greg Locock


New here? Try reading these, they might help FAQ731-376

http://eng-tips.com/market.cfm?

 

[BrCo]

Perfect. Thanks a lot!