A 1

B 0 (or blank)

C 0 ""

A 2

C 0

A 3

B 0

C 0

A 4

This information is then pulled across to another sheet which I have already worked out the formula for, however I would like it to leave an empty display rather than an #N/A answer. The formula I am using is this:

=INDEX(Sheet1!C$2:C$119,MATCH($A2,Sheet1!$Z$2:$Z$119,0))

Any help or pointers in the right direction would be appreciated.

Many Thanks