Excel functions

%3CLINGO-SUB%20id%3D%22lingo-sub-2691858%22%20slang%3D%22en-US%22%3EExcel%20functions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2691858%22%20slang%3D%22en-US%22%3E%3CP%3EHello!%20I%20would%20like%20some%20help%20form%20an%20expert%20please!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20document%20that%20I%20would%20like%20to%20insert%20a%20function%20in%20whereby%20%22%20if%20Cell%201%20contains%20the%20numbers%201%2C2%2C3%2C4%2C5%2C6%2C7%2C8%2C9%20or%2010%2C%20then%20display%20cell%201%2C2%2C3%2C4%2C5%2C6%2C7%2C8%2C9%20or%2010%20from%20sheet%202%20in%20sheet%201%20(then%20give%20a%20destination%20cell%20number%2Fletter%20for%20this%20to%20be%20placed%20in).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBasically%20I%20have%20a%20random%20generator%20function%20whereby%20I%20want%20to%20input%20a%20number%20from%20a%20range%20(1-10%2C11-20%20and%20so%20on)%20that%20has%20a%20list%20of%20questions%20on%20another%20sheet.%20So%20when%20its%20refreshed%20and%20places%20the%20number%20(for%20instance)%202%2C%20then%20question%202%20will%20be%20displayed%20in%20sheet%201%20corresponding%2C%20and%20so%20on.%20Each%20time%20the%20number%20changes%2C%20it%20will%20draw%20it%20the%20relevant%20question%20that%20goes%20with%20that%20number.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20that%20makes%20sense!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2691858%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%3CLINGO-SUB%20id%3D%22lingo-sub-2692497%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20functions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2692497%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1139317%22%20target%3D%22_blank%22%3E%401ucy_8%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPerhaps%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-excel-formula%22%3E%3CCODE%3E%3DINDEX(Sheet2!%24B%242%3A%24B%2411%2C%20MATCH(C1%2CSheet2!%24A%242%3A%24A%2411%2C0))%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3EPlease%20check%20in%20attached%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hello! I would like some help form an expert please!

 

I have a document that I would like to insert a function in whereby " if Cell 1 contains the numbers 1,2,3,4,5,6,7,8,9 or 10, then display cell 1,2,3,4,5,6,7,8,9 or 10 from sheet 2 in sheet 1 (then give a destination cell number/letter for this to be placed in).

 

Basically I have a random generator function whereby I want to input a number from a range (1-10,11-20 and so on) that has a list of questions on another sheet. So when its refreshed and places the number (for instance) 2, then question 2 will be displayed in sheet 1 corresponding, and so on. Each time the number changes, it will draw it the relevant question that goes with that number.

 

Hope that makes sense!

5 Replies

@1ucy_8 

Perhaps

=INDEX(Sheet2!$B$2:$B$11, MATCH(C1,Sheet2!$A$2:$A$11,0))

Please check in attached

@Sergei Baklan Thank you. Dont think thats it though. I want the question on sheet 2 to appear in sheet 1 column c, depending on the number thats randomly generated in B1. Not sure if that can be done as its randomly generated. But effectively in B1, those questions will only be from 1-10 from sheet 2. Then B2 will be questions from 11-36 from sheet 2.

@1ucy_8 

Could you please provide sample file?

@Sergei Baklan Sure - attached for you 

@1ucy_8 

I see, thank you. I'd recommend questions in Shift2 on two columns - in column A is the number and in column B is the text of the question. Otherwise possible solution will be much more complicated and depends on Excel version you use.