I have data in a column in my data sheet that I want to reference on several other sheets in the same workbook ONLY if it displays a certain character.
For example -
data sheet 1 cells are:
Smith (H)
Bob (Z)
Doe (R)

Sheet 2 needs to only display the cell if it has (H); sheet 3 only needs to display the cell if it has (Z); sheet 4 only needs to display if cell has (R).
I have excel 2010.
How the HECK do I write this formula? I know there's got to be a way to do it, I just have no idea how! I'm incredibly frustrated! Help!
Thanks.