special lookup

[Guest]

I am looking for a function or combination of functions that will return the
1st value in an array not equal to specified cell or cells.

Hope you can help.

Thanks,

 

[T. Valko]

Post an example.