1 Attachment(s)
Matching values using formula
Attachment 24274
Hello everyone i have this table and i need to get the values from left side and put into the right one. I have explaind everything into the table. i have tryed some excel formulas like lookup and some others but i dint finalize anything. If you help me ill appriciate that. Thanks in advance.
1 Attachment(s)
Transform formula into vba-code.
I have atached the workbook here, and the formula. The work is done but as long as the nested IF formula is up to 7 times and my range is bigger than this i need a loop through this to complete my range. The formula takes the cell with values make the diff between these two values and if the 2 conditions are meet the values are copied in that range to the specified cell(J3, K3, L3) in L3 is the value in the second row that belongs to the column where the value is finded.
1 Attachment(s)
Transform formula into vba-code.
I have atached a real copy of the workbook and i have described in the end what values i need to match.