Using VLookUp to return True or False

[bishoposiris]

I'm trying to accomplish the following:

If a value in cell A1 on Sheet Report is found in Range B2:B10 on Sheet Hierarchy Then return True Else False

I have the following so far:

Please Login or Register  to view this content.

I want Match to be either True or False. Also, is there a way to know the cell the value was found in if True? How do I make this work?

[MrShorty]

I think I would use the countif function rather than the vlookup function:

Please Login or Register  to view this content.

or something similar