Need Help Creating This Link Between Sheets

%3CLINGO-SUB%20id%3D%22lingo-sub-1189098%22%20slang%3D%22en-US%22%3ENeed%20Help%20Creating%20This%20Link%20Between%20Sheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1189098%22%20slang%3D%22en-US%22%3E%3CP%3EOnce%20again%20I%20seek%20the%20knowledge%20of%20the%20community.%3C%2FP%3E%3CP%3ESo%20I%20have%20this%20self%20compiling%20list%20in%20column%20F%20that%20has%20been%20made%20by%20the%20formula%20%3DFILTER(A1%3AA479%2CC1%3AC479%3D%22Y%22)%20and%20in%20G%20via%20a%20almost%20identical%20formula%20but%20to%20pull%20the%20values%20in%20the%20same%20row%2C%20as%20can%20be%20seen%20in%20the%20image%20below.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22examp1.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F172806iBE93BF434473AC1B%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22examp1.png%22%20alt%3D%22examp1.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3ENow%20I%20have%20%3CU%3E%3CSTRONG%3E%3CA%20href%3D%22https%3A%2F%2Fwarframe.fandom.com%2Fwiki%2FVoid_Relic%2FByRewards%2FSimpleTable%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3ETHIS%3C%2FA%3E%3C%2FSTRONG%3E%3C%2FU%3E%20website%20that%20has%20the%20same%20information%20I%20have%2C%20in%20a%20boxed%20style%20like%20used%20in%20excel%2C%20that%20is%20split%20between%20the%20columns%20labeled%20Item%20and%20Part.%20What%20I've%20done%20is%20taken%20the%20information%20and%20made%20it%20to%20pull%20the%20data%20to%20into%20sheet2%20with%20the%20columns%20Item%20and%20Part%20together%20Renamed%20as%20Item%2C%20so%20it%20matches%20the%20same%20thing%20I%20have%20on%20my%20list%20on%20sheet1%2C%20changed%20Tier%20to%20Relic%20Class%2C%20Name%20to%20Relic%20ID%20and%20set%20the%20data%20to%20automatically%20background%20refresh.%20This%20all%20can%20be%20seen%20below.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22examp2.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F172807iFE10355404A12498%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22examp2.png%22%20alt%3D%22examp2.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3ENow%20what%20I%20want%20to%20do%20is%20essentially%20trying%20to%20create%20a%20filterable%20search%20list%20that%20interlinks%20the%20two%20in%20a%20matter%20of%20speaking%20on%20sheet1.%20Below%20you%20will%20see%20the%20box%20outline%20created%20where%20I%20want%20to%20put%20this.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22examp3.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F172809iBE0D53C5B5A5357A%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22examp3.png%22%20alt%3D%22examp3.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EThe%20merged%20box%20spanning%20from%20boxes%20I4-L4%20will%20be%20a%20drop%20down%20box%20that%20consists%20of%20the%20the%20items%20that%20are%20in%20column%20F.%20I%20then%20want%20to%20have%20each%20of%20the%20boxes%20in%20row%207%20to%20be%20a%20drop%20down%20filter%20option%20corresponding%20to%20that%20labeled%20in%20the%20box%20above%20with%20the%20options%20listed%20to%20the%20right%20%3CEM%3E(There%20for%20explanation%20and%20not%20in%20the%20final%20product)%3C%2FEM%3E.%20Then%20the%2020%20boxes%20below%20the%20second%20set%20of%20labels%20would%20then%20would%20display%20a%20list%20of%20sources%20that%20meet%20this%20criteria.%20If%20possible%20I'd%20also%20like%20to%20be%20able%20to%20make%20so%20if%20I%20leave%20the%20item%20box%20in%20I4-L4%20blank%20it%20will%20leave%20the%20result%20boxes%20blank%20like%20they%20show%20in%20the%20above%20image.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1189098%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

Once again I seek the knowledge of the community.

So I have this self compiling list in column F that has been made by the formula =FILTER(A1:A479,C1:C479="Y") and in G via a almost identical formula but to pull the values in the same row, as can be seen in the image below.

examp1.png

Now I have THIS website that has the same information I have, in a boxed style like used in excel, that is split between the columns labeled Item and Part. What I've done is taken the information and made it to pull the data to into sheet2 with the columns Item and Part together Renamed as Item, so it matches the same thing I have on my list on sheet1, changed Tier to Relic Class, Name to Relic ID and set the data to automatically background refresh. This all can be seen below.

examp2.png

Now what I want to do is essentially trying to create a filterable search list that interlinks the two in a matter of speaking on sheet1. Below you will see the box outline created where I want to put this.

examp3.png

The merged box spanning from boxes I4-L4 will be a drop down box that consists of the the items that are in column F. I then want to have each of the boxes in row 7 to be a drop down filter option corresponding to that labeled in the box above with the options listed to the right (There for explanation and not in the final product). Then the 20 boxes below the second set of labels would then would display a list of sources that meet this criteria. If possible I'd also like to be able to make so if I leave the item box in I4-L4 blank it will leave the result boxes blank like they show in the above image.

0 Replies