Including in a range
=IF(ISNA(MATCH($A$2,$B$1:$B$5,0)),"",$A$1)
" wrote:
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
|