Including in a range

[Brian.Hastings82]

Hi guys, hopefully you can help..

Cell A1 - Persons Name
Cell A2 - Drop down list Z1,Z2,Z3,Z4,Z5
I have a range of cells (B1:B5) in these cells could will be text,
either Z1,Z2,Z3,Z4orZ5


I need some kind of lookup to look in cells from B1:B5.

If one or more of these cells equals A2 the answer should be A1, or if
it doesnt blank.

Hope this makes sense!

Brian

 

[Guest]

=IF(ISNA(MATCH($A$2,$B$1:$B$5,0)),"",$A$1)