Hi everyone,
I would like someone to help me out in this.
The requirement is to match the values (criteria) in two columns and return the corresponding value in the 3rd column. The catch here is that the two columns where the criteria is to be matched can be in any order. Have attached the image below for reference with the required results. Could not attach the excel file (i don't know why).
Criteria_Combination.jpg
I am not able to find a way to do this with VLookup.
Hope its not too difficult an issue. If this problem has been solved elsewhere on this forum, please direct me there..
Thank you
Regards,
Azeem
Bookmarks