Trying to adjust this formula to suit my needs, but since it was not working in the first place I was unable to make it work myself. The output also included blank values, making the output "Force damage,, Acid damage, ".
Compare two lists for matches excel 2016 mac code#
Executing the code made my device struggle, which does not bode well for viewing of this file on mobile. A user-defined VBA function as suggested here. I was also unable to cleanly combine the outputs because of 0 and Value Not Available outputs. This is not ideal because I need to manually decide how many items to check. Turning List B into a column of items, every item in a unique cell, allowing me to VLOOKUP every individual item. Maybe an array? Outputting them to a column is probably more practical, from what I've seen so far. I'd rather avoid VBA if possible.īecause resistances can also come from sources other than magic items, ideally the output would be in a shape I can combine it with similar outputs for sorting / duplicate checking purposes. My desired output would be, in this case, a list of all resistances a character has: "Force damage, Acid damage" or a similar syntax. I am trying to create a formula that returns the values from column D of List A for every item that exists in List B, provided the cell is not empty. List B contains the character's inventory.
List A contains magic items and some of their properties. Recent ClippyPoint Milestones !Ĭongratulations and thank you to these contributors DateĪ community since MaDownload the official /r/Excel Add-in to convert Excel cells into a table that can be posted using reddit's markdown. Include a screenshot, use the tableit website, or use the ExcelToReddit converter (courtesy of u/tirlibibi17) to present your data. NOTE: For VBA, you can select code in your VBA window, press Tab, then copy and paste that into your post or comment. To keep Reddit from mangling your formulas and other code, display it using inline-code or put it in a code-block This will award the user a ClippyPoint and change the post's flair to solved. OPs can (and should) reply to any solutions with: Solution Verified