Hi,

You may want to refer my article on the following link

http://office.microsoft.com/en-us/ex...CL100570551033

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Patrick" wrote in message
...
Hello,
I searched through the threads and tried using some of Biff's array
formulas, but not with any success. I believe I'm missing a step or two.
An
excerpt of my data is as such:

C D N O
P
1 File # Dept File # 120004
120009
2 100121 120009 100120 N/A N/A
3 100127 120009 100121 N/A 120009
4 100137 120009 100129 N/A N/A
5 100145 120009 100137 N/A 120009

I think the best way for me to explain what I'm trying to do is to show
you
the formula I came up with before this post:

=IF((VLOOKUP($N2,$C$2:$D$5,2,FALSE)=$O$1),$O$1,"N/A")

This worked until I learned that Column C has duplicates. For example,
File
#100695 can belong to Dept 120009, 120063, and 120092.

Any thoughts or suggestions? I have a feeling I'm making things more
complicated than necessary. I'd greatly appreciate any help.

Kind regards,
Patrick