In the last few minutes I have found that the original formula does not
always return a correct answer. Is there something else that will return more
consistant results? As to the the LOOKUP and VLOOKUP functions, could the
table reside on the hidden "personal.xls" workbook that I save my macros on?

Thank you!

"Luke M" wrote:

Put each OR function inside a IF function, like so:

=IF(OR(D2=27028,D2=27076,D2=27286),"Tim's","")
=IF(OR(D2=27310,D2=27312),"Bobby's","")
...etc.


Of note, guessing on how's your setting up your formulas, you might want to
look at the LOOKUP and VLOOKUP functions. I'm thinking you could set up a
table somewhere that lists the numbers you are checking, correlated with
names. Might save you some time. But again, just speculating based on these
few formulas.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"fgwiii" wrote:

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!!