[COLOR=”#FF8C00″][B]Hello guys.
[/B][/COLOR]
I’m kinda new to Excel, and I need your help.
So, I need to instruct a [B][SIZE=3]form-like[/SIZE][/B] sheet in Excel to be as follows:
[table “” not found /]
The current situation:
[LIST]
[*]I have the products already listed alongside their prespective codes in Sheet1, and I already established a successful formula to calculate the pricing and so on…
[/LIST]
[hr][/hr]
The required results:
[LIST]
[*][SIZE=3][COLOR=”#800080″]I want a formula to lookup in a certain row (starting from a certain column and to infinity) to check for the entered values, and return them into the table in Sheet2 in the column titled quantity (each quantity in a separate row if possible).[/COLOR][/SIZE]
[*][SIZE=3][COLOR=”#800080″]In the column titled Name I need to list the corresponding product-names each a cell after its own needed quantity.[/COLOR][/SIZE]
[*][SIZE=3][COLOR=”#800080″]Obviously, I need to enlist the product-codes for the corresponding products into the column titled Code.[/COLOR][/SIZE]
[*][SIZE=3][COLOR=”#800080″]And clearly, the fourth column titled Price is for the corresponding product-prices each in front of each’s product code.[/COLOR][/SIZE][/LIST]
[hr][/hr]
What I have in mind:
[LIST]
[*]I thought of using an if statement different in each column, i.e. in the “Quantity” column and is changed correspondingly for the other columns, structured as follows:
[LIST]
[*][COLOR=”#008080″][SIZE=3]if the selected range has an entered value; return the values found (each in a separate row in the same column, if no value is found it would return “blank” or a dash, i.e. “-“[/SIZE][/COLOR];
[*][COLOR=”#800000”][SIZE=3]the other three columns would just have different range matrices but it would be the same structure.[/SIZE][/COLOR]
[/LIST][/LIST]
[HR][/HR]
[i]I think the problem is just finding the structure of the needed equation for one of the columns or even for one cell in each column; as each column might have at most 20 rows that can be easily edited whenever required.[/i]
Thanks for whoever can help.