intersections value in columns formula

Hi I have 4 columns and I want to find the intersection numbers in this columns with formula:

Please Login or Register  to view this content.

the output must be number (2)

Assuming that Column A is the tallest one, then we will use Vlookup on its cells
try typing this code on cell F2
=(VLOOKUP(A2,B:B,1,0)+VLOOKUP(A2,C:C,1,0)+VLOOKUP(A2,D:D,1,0))/3