Lookup in SharePoint?

I have a SharePoint site with a long list of events (including thelocations of all events). I also have a separate list of zip codes, andI need to be able to identify the events that occur within any of thezip codes in my list (just a yes/no flag in a calculated column wouldbe fine). I have no problem doing this in Excel - I've been using theCOUNTIF function. But I haven't been able to figure out how toreplicate this in SharePoint. Does anyone have any suggestions?

Share:

1 Answer Found

As I dont know if the lists reside in the same site or not, I suggestthat if you need look up column cross site, you can use this solution:www.sharepointboost.com/Cross-SiteLookup.htmlIt provide more than cross-site lookup function for you, you can filterfield and convert cross-site lookup into default lookup field.

Go4Sharepoint, is a Microsoft Featured Community.
Microsoft, Windows, Sharepoint, Sharepoint logo, Windows logo, etc are trademarks of the Microsoft Corporation.
All product names, logos, copyrights, and trademarks mentioned are acknowledged as the registered intellectual property of their respective owners. This site is not in any way affiliated with, nor has it been authorized, sponsored, or otherwise approved by, Microsoft Corporation.