Lookup function in row not functioning

Hi!

I've been trying to figure this out all day and I'm pretty sure it's not a difficult formula, but I just can't seem to get it right.

What I would like to do is to look at a cell value (A1) and see if it is located in a row. So cell A1 contains the value, which can be changed as it is a drop-down list. And what I want is to search each row, and if the value in A1 is found in that row, then I want the "Student Name (col B)" to populate in column A of that row. If it doesn't appear, then leave blank.

I attached a sample workbook with information, including a formula I used that seemed to work but not well.

Thanks in advance!

- Santana

Try this formula in A2 copied down

=IF(COUNTIF(B2:AI2,A$1),A$1,"")

DDL's typo, should be (based on your post)

=IF(COUNTIF(B2:AI2,A$1),$B2,"")

Ah, yes, that's more like it ChemistB, thank you