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