Generate Output Based on Pre-Defined Rules

Please see attached file.

Attachment 146659


Column A contains a sorted list of items. (I organized the items through Excel's sorter.)

Column B represents column A's ranks (ranks are values for adjacent cells).

Column F functions the same way as column B, except it represents column E's ranks. However, the values of column F can be changed to render new values for column E.


Problem:

I need to list all possible values for Column E based on data given from column A, B, and F. Because I can change the values of column F, I simply want to input values into that column and let Excel figure out the values for column E automatically.

** The output values for column E must follow the same order as column A. (I organized column A by using a complex sorting algorithm; they're organized by "rarity." The given ranks in column F help decipher the outcome of column E.)

-- I could do it manually, but it's tedious to perform the same guess work over and over.

Any assistance would be greatly appreciated.