If statement - same row in 2 different columns

[MrsStew]

Hello,

I am trying to create an if statement that will look at the exact same row as the cell I'm in, only in a different column.

I want it to say "if('Sheet2'!F:F="A","A",if('Sheet2'!F:F="B","B",if('Sheet2'!F:F="C","C","Not Found"))) but I want it to be row specific. For example, formula entered into cell A2 on Sheet 1 to pull from B2 on Sheet 2, only hundreds of times over.

Please help!

-Mrs. Stewart

[berlan]

Not sure I totally follow, but in A2 on Sheet1, try,

=IF(SUM(COUNTIF(Sheet2!A2,{"A","B","C"})),Sheet2!A2,"Not Found")

and copy down.