| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Including in a range
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| multiple lookup including date range | Excel Worksheet Functions | |||
| MAX/MIN in range potantially including text | Excel Worksheet Functions | |||
| How do I get excel to sum a range without including hidden cells? | Excel Worksheet Functions | |||
| Average range including blank cells: #DIV/0! | Excel Worksheet Functions | |||
| Multiple criterion including wildcards to sum in a range | Excel Worksheet Functions | |||
Hybrid Mode
