Thread watchedQuestion Many IFS in dependent drop down list.

%3CLINGO-SUB%20id%3D%22lingo-sub-3084685%22%20slang%3D%22en-US%22%3EThread%20watchedQuestion%20Many%20IFS%20in%20dependent%20drop%20down%20list.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3084685%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EI%20have%20tried%20in%20put%20these%20ifs%20in%20the%20data%20validation%20to%20make%20dependent%20drop%20down%20list%2C%20however%2C%20it%20only%20works%20with%202%20statements.%20After%20that%20it%20doesn't%20show%20what%20I%20want.%20And%20I%20want%20to%20make%20a%20lot%20of%20ifs.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E%3DIFS(%E0%B8%A3%E0%B8%B2%E0%B8%A2%E0%B8%81%E0%B8%B2%E0%B8%A3%E0%B8%AA%E0%B8%B1%E0%B9%88%E0%B8%87%E0%B9%80%E0%B8%AB%E0%B8%A5%E0%B9%87%E0%B8%81!B2%3D%22%E0%B8%89%E0%B8%B2%E0%B8%81%22%2COFFSET(Sheet1!%24E%241%2C1%2C0%2CCOUNTA(OFFSET(Sheet1!%24E%241%2C1%2C0%2C30)))%2C%E0%B8%A3%E0%B8%B2%E0%B8%A2%E0%B8%81%E0%B8%B2%E0%B8%A3%E0%B8%AA%E0%B8%B1%E0%B9%88%E0%B8%87%E0%B9%80%E0%B8%AB%E0%B8%A5%E0%B9%87%E0%B8%81!B2%3D%22%E0%B8%A3%E0%B8%B2%E0%B8%87%E0%B8%99%E0%B9%89%E0%B8%B3%22%2COFFSET(Sheet1!%24H%241%2C1%2C0%2CCOUNTA(OFFSET(Sheet1!%24H%241%2C1%2C0%2C30)))%2C%E0%B8%A3%E0%B8%B2%E0%B8%A2%E0%B8%81%E0%B8%B2%E0%B8%A3%E0%B8%AA%E0%B8%B1%E0%B9%88%E0%B8%87%E0%B9%80%E0%B8%AB%E0%B8%A5%E0%B9%87%E0%B8%81!B2%3D%22%E0%B8%A3%E0%B8%B2%E0%B8%87%E0%B8%9E%E0%B8%B1%E0%B8%9A%22%2COFFSET(Sheet1!%24KE%241%2C1%2C0%2CCOUNTA(OFFSET(Sheet1!%24K%241%2C1%2C0%2C30))))%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3EThe%20table%20I%20would%20like%20to%20make%20is%20to%20be%20able%20to%20just%20click%20click%20each%20size%20of%20the%20steel%20I%20wanna%20order%2C%20and%20each%20type%20of%20steel%20has%20it%20own%20sizing%20method.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3084685%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
Occasional Visitor

I have tried in put these ifs in the data validation to make dependent drop down list, however, it only works with 2 statements. After that it doesn't show what I want. And I want to make a lot of ifs.
=IFS(รายการสั่งเหล็ก!B2="ฉาก",OFFSET(Sheet1!$E$1,1,0,COUNTA(OFFSET(Sheet1!$E$1,1,0,30))),รายการสั่งเหล็ก!B2="รางน้ำ",OFFSET(Sheet1!$H$1,1,0,COUNTA(OFFSET(Sheet1!$H$1,1,0,30))),รายการสั่งเหล็ก!B2="รางพับ",OFFSET(Sheet1!$KE$1,1,0,COUNTA(OFFSET(Sheet1!$K$1,1,0,30))))
The table I would like to make is to be able to just click click each size of the steel I wanna order, and each type of steel has it own sizing method.

1 Reply