SharePoint lookup column error:
“Value does not fall within the expected range”.
This lookup column error is very generic and can be very frustrating too especially when you have taken care to ensure that everything is right. I have often encountered this error when working with SPListItem values for lookup columns, people pickers and choice columns.

When the out of the box SharePoint approval workflow publishes an item, it sets the “Modified by” field as “System Account” instead of setting this to the actual user who did the approval. One way around this could be to add another column to hold the correct Modified by user instead of the out of the box Modified by column. But since not all clients will be satisfied with this approach, I will explain another way here.

I have done quite a bit of programmatic manipulation on the SharePoint quick launch bar in C# so I decided to write this article that logs some of the tips and tricks I have used. Here you will find how to add and delete items, update links and text in parent and children nodes, add headings (items without links), add links that open in new window, and handle audience targeting for specific quick launch links.