Hi Max

Very nice solution!!

--
Regards

Roger Govier


"Max" <demechanik@yahoo.com> wrote in message
news:O0s9UqdRGHA.252@TK2MSFTNGP10.phx.gbl...
> Oops, missed out including the X!A2="" bit in the error traps
>
> Lines
>> In G2:
>> =IF(OR(X!B2="",$A$1="",$B$1=""),"",IF(AND(X!A2=$B$1,X!B2=$A$1),ROW(),""))
>>
>> In N2:
>> =IF(OR(X!E2="",$H$1="",$I$1=""),"",IF(AND(X!A2=$I$1,X!E2=$H$1),ROW(),""))
>
> should read as:
>
> In G2:
> =IF(OR(X!A2="",X!B2="",$A$1="",$B$1=""),"",IF(AND(X!A2=$B$1,X!B2=$A$1),ROW()
> ,""))
>
> In N2:
> =IF(OR(X!A2="",X!E2="",$H$1="",$I$1=""),"",IF(AND(X!A2=$I$1,X!E2=$H$1),ROW()
> ,""))
>
> (Revised sample file corrected)
> --
> Max
> Singapore
> http://savefile.com/projects/236895
> xdemechanik
> ---
>
>