Hello Community, wondering if I can get some help here. I am looking for a formal that will take a selected value and then look for it on another sheet that could be in any column. Is this possible?
If you don’t know which column where your data can be found, then you definitely have a problem of data modeling, and you’ll keep running into more problems.
Please read this guide:
https://help.appsheet.com/en/articles/895267-data-the-essentials
3 Likes
So one table is called “equipment info”, the other table is called “filter info”. The equipment info table as columns due to I need to identify each filter separately and how many specific filter the equipment needs. Example of columns “Engine oil filter” . “Qty” “Fuel Filter”, “Qty2”, “Air Filter”, “Qty3” and so on for all the other components it needs. Now the other table called “filter info”, and its columns are setup like this “type of filter”, “brand name”. “part number”, “style of filter”. What I want to do is when I select “part number” I like it to associate that part number to what units in the other table that uses that filter type?
You need to restructure your tables; for your data should be in rows not columns. I strongly encourage you to read these guides and come back to ask if you have any difficulties:
1 Like