Hi,

In my Worksheet [Col c] is have the following code which performs the required Function set for it.
But when the rows do not contain the right data it end up with #N/A
now I know I need to wrap this array within a code which will remove/replace the #N/A
So the question is how do I wrap the code within the function required.

=INDEX($R$21:$R$37,MATCH(G29,INDEX($R$21:$R$37,0,1))+ (G29<>VLOOKUP(G29,$R$21:$R$37,1)),$F$1)

regards

Barry