Obtain rows with conditionals in another sheet

    posted on behalf of user "Danielrmz" :
    =========================


    I want to know if there ir any way, to do the following:


    -I have a list in sheet1, with names, values, discounts, etc.


    I want to know if there is any function that i can use. I want to have a cell in sheet2, that if i put a number, for example 2, bring me back 2 or 3 different rows from sheet 1.


    for example if the number of the cell is 3, I want to bring to the same sheet (sheet2), the complete row number 165 and the complete row number 174
    but if the number of the cell is 7, i need to bring different rows for example 12 and 5, but i will never end using ifs, also it only can be 7 nested.


    what can i use?


    thanks

    maybe its too early in the morning for me but i can't see a relationship between the numbers entered and the rows required.


    :question:

    There are three types of people in this world.
    Those who can count and those who can't.

    This can no doubt be done, but you need to be more specific about the relationship between the number you enter & the rows you want return. The relationship between "if 3, then 165 and 174" and "if 2 then 12 and 5" is opaque to say the least.


    please post back with more info...if you can't define what the relationship is, we can't devise a formula / code that implements it.


    paddy

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login