Hello all,

I am having trouble implementing a complex (at least by my standards...) lookup function. I want a cell, let's say it's C3, to check the text in B3 against a list of names and return true if it's on there and false if it isn't.

I can't use VLOOKUP because I need the contents of the A column to be first.

Any help would be much appreciated!