Just wondering if anyone knows how to return a value in index and match, that is not equal to a value in another cell or range of cells. My current formula is:

=INDEX($C$6:$C$9,MATCH($B$27,$D$6:$D$9,0),)

I need to somehow embed a <> function in here.

I have researched lookup, match and index and can't find the answer anywhere - help!

Thanks...