Tip: Other languages are Google-Translated. You can visit the English version of this link.
Log in


How to lookup name between two sheets based on a selected parameter

  • Vijit Kumar
  • Topic Author
  • Offline
  • New Member
  • Nouveau membre
2 months 3 weeks ago #1321 by Vijit Kumar
At any given point of time a value from a specific column for eg: name will be compared between two sheets for a specified parameter for eg: Team size. The challenge though is that there should be a provision to select the first and second sheet in which the specific column and the specific parameter needs to be compared

The attached file has all the details. I will outline the logical flow of events

Step1: Select first sheet for comparison
Step2: Select second sheet for comparison (both these steps should be achieved through some automation and not manually)
Step3: Specify the value to be looked up. For eg: in this case, "Sam" from "name" column.
Step4: Specify the parameter to be compared for Sam. In this case, "Team size".
Step5: Value in first sheet for Sam-Text size to be returned
Step6: Value in second sheet for Sam-Text size to be returned
Step7: Compare the two values and say whether they match or do not match.

I have managed to figure out only Step 7 so far :-)

Please Log in or Create an account to join the conversation.

  • Not Allowed: to create new topic.
  • Not Allowed: to reply.
  • Not Allowed: to edit your message.
Moderators: jaychivoJay Chivo