Hello,
Is it possible to perform a vlookup, or some other lookup function, in a 2D list of data against two excel columns that contain multiple values?
For example, I have an excel with 5 columns. Out of which Column C contains a list of BP_IDs. Some cells here have a repeated Staff ID and Column D contains a list of MBB_Names. Some cells here have a repeated MBB_Names too and column E has voting values in the form of "Yes","No" or "Abstain". Here basically MBB has to vote on each BP_ID with values "Yes","No" or "Abstain".
BP_ID MBB Name Created Vote
930201084637 Jef 9/30/10 Yes
930201084637 Pau 9/30/10 No
930201084637 Rob 9/30/10 Abstain
91201011002 Jef 9/30/10 Yes
I have created a column F where i have listed all the MBB names and Column G where i have singled out all the unique BP_Ids. I want to match these 2 columns F & G to the columns C & D and find out who are the MBBs that have not voted yet by comparing each BP_Id and MBB name as composite key to the columns C & D.
I hope this makes sense. If you need me to clarify let me know.
Many thanks,
Rasmi
Is it possible to perform a vlookup, or some other lookup function, in a 2D list of data against two excel columns that contain multiple values?
For example, I have an excel with 5 columns. Out of which Column C contains a list of BP_IDs. Some cells here have a repeated Staff ID and Column D contains a list of MBB_Names. Some cells here have a repeated MBB_Names too and column E has voting values in the form of "Yes","No" or "Abstain". Here basically MBB has to vote on each BP_ID with values "Yes","No" or "Abstain".
BP_ID MBB Name Created Vote
930201084637 Jef 9/30/10 Yes
930201084637 Pau 9/30/10 No
930201084637 Rob 9/30/10 Abstain
91201011002 Jef 9/30/10 Yes
I have created a column F where i have listed all the MBB names and Column G where i have singled out all the unique BP_Ids. I want to match these 2 columns F & G to the columns C & D and find out who are the MBBs that have not voted yet by comparing each BP_Id and MBB name as composite key to the columns C & D.
I hope this makes sense. If you need me to clarify let me know.
Many thanks,
Rasmi