Need help with LS and lookups

HiI’m new i LS and try to understand how a will return values from column two based on value from column one. And the get values from a second view based on first values.

First View (Status)

First column is a categorized column with three different values. Pending, Active and Archive. Second column contains e-mail addresses. There could be more then one document under Active so there could be more then one e-mail address.

Second View (StatusSend)

First column is a categorized column with three different values. Pending, Active and Archive. I will send e-mail to all person there value is Active in the categorized first column.

The e-mail addresses i will use is the addresses it return from first View (Status) and i even want to sen a URL to the document i return here. I guess i will use DocumentUniqueID

Anyone who could explain this for me the easy way or have any good example how i will do this.

Excuse my poor english.

Regards

Moses