Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Earlier in the week someone was kind enough to provide me with the following
code that allowed me to search for different numbers in a column and provide me with a answer of True or False. While that was extreme helpful, I was wondering if it is possible to search and depending on the values, return a person's name as shown below. =OR(D2=27028,D2=27076,D2=27286) Tim's =OR(D2=27310,D2=27312) Bobby's =OR(D2=27670,D2=28088,D2=28094) Alex =OR(D2=28291,D2=28386,D2=28488,D2=28630) Sally's Thank you for your assistance. Your help is Greatly Appreciated!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Filter duplicates by multiple criteria | New Users to Excel | |||
Filter Multiple Columns on Multiple Criteria and count the last co | Excel Worksheet Functions | |||
Best Way for Multiple Criteria to Show From a Filter | Excel Discussion (Misc queries) | |||
Filter a range of data with multiple criteria | Excel Discussion (Misc queries) | |||
Create macro to filter on multiple criteria | Excel Worksheet Functions |