I need a formula that can get me a value from a column that has unique values and return another cell from that row, can someone help me? ex table below.
ex lets say i need to find value 3 from column G12 and return B12 or concatenate 2 or more cells.
i forgot to mention that we use only Excel 2003.
How to find value from a column with unique random values