Hey All:
This should be simple, but I can't think of the best way to write this formula. I have a huge access listing with e-mail addresses in one column and access rights in another column. There are duplicate e-mail addresses if the individual has multiple access rights. I need to write a lookup where I define the e-mail address and the access right and the formula will identify if both are found in the listing.
Thanks in advance!
Justin
This should be simple, but I can't think of the best way to write this formula. I have a huge access listing with e-mail addresses in one column and access rights in another column. There are duplicate e-mail addresses if the individual has multiple access rights. I need to write a lookup where I define the e-mail address and the access right and the formula will identify if both are found in the listing.
Thanks in advance!
Justin