Data Validation / Offset Formula

Originally Posted by Fotis1991

So In B6 you choose "NBF". Then where do you want to have the option "TR or LC"? And then, where the Type & Category. In the same cell?

Please consider sheet one as an example (full is raw form which i m working to reform, that's why it will confuse you)