SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm updating a list that requires Lookup Details on 2 fields, but I can't for the life of me see how to do that. Is it possible?

share|improve this question

I am not 100% sure what you are trying to do, but I think the following answers your question providing you are talking about a SharePoint designer workflow and not a Visual Studio one.

  1. create a workflow variable for each lookup
  2. Add the 'Set Workflow Variable' workflow action for each lookup.
  3. For each action set the name of the variable and click the Workflow Lookup button (fx) to carry out the lookup.

For full details and an example see this post.

share|improve this answer
Thank-you very much for the response, Muhimbi. What I am trying to do is this... I have a list as follows: Name | Leave Type | Leave Taken | Balance There are 7 Leave Type's for each person. I need a workflow (using SharePoint Designer) that will update the appropriate "Leave Taken". For example, if employee John Doe takes 2 days of Vacation Leave, I need to update the Leave Taken field next to the Vacation "Leave Type" for John Doe. So my workflow needs to lookup the "Name" and "Leave Type" fields and then update the "Leave Taken" field. I hope that makes sense :) – Anonymous Jun 15 '10 at 15:34
That is clear, my assumptions were correct and all the information you need is in my answer and the linked article. Have fun. – Muhimbi Jun 15 '10 at 15:50
Great! Thank-you so much for your response and for all of your help. Have fun? I most certainly will! – Anonymous Jun 15 '10 at 16:19
I don't see how this answers the question. The OP requires lookup on TWO fields. – Christophe Nov 11 '10 at 5:12

AFAIK there is no straightforward way to do a lookup based on two fields.

Here are two workarounds:

  • create an additional column that concatenates the two fields (using a calculated column or a workflow). You can then lookup this concatenated field.
  • create a looping workflow that will go through all the items that match the first field, and then performs a lookup on the second field. This is an advanced customization and actually requires two interlaced workflows.
share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.