Need Count value from document library and display as look up in list

Question

I have a document library Doclib and a list Doclist.

Doclib has columns: Title, Approval Status, Projname(Lookup).
Doclist has Columns: ProjectName, Count(Want to lookup)

The ProjName column is a look up column which fetches ProjectName from Doclist.

I want the column Count to look up how many times a particular project is selected.

Example:

DocLib

Title   Approval Status  ProjName

Document1   Draft    Project 1
Document2    Draft    Project 2
Document3    Draft    Project 1
Document4    Draft    Project 3
Document5    Draft    Project 1
Document6    Draft    Project 2

DocList

ProjectName   Count

Project 1   3
Project 2   2
Project 3   1

Any help would be really appreciated.

Answer 1

You can achieve this with two lookup columns:

1. Create a lookup column in DocLib that points to itself, column 'ProjName'. Call this column 'ProjNameLookup'.
2. Create a lookup column in DocList that points to DocLib, column 'ProjNameLookup (Count Related)'

See here for a guide.