# How to find value from a column with unique random values [Solved]

Ask a question student123456 3Posts Sunday November 13, 2016Registration date November 13, 2016 Last seen - Last answered on Nov 13, 2016 at 04:37 PM by student123456
Hello,

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.
random

Thank you.
i forgot to mention that we use only Excel 2003.
+1
Try this formula :
=OFFSET(B1;MATCH(3;G:G;0)-1;0)

It will search for the value 3 in column G, and return the value present in column B from the line where 3 is present in column G.
student123456 3Posts Sunday November 13, 2016Registration date November 13, 2016 Last seen -
Thank you very much for such a quick and good answer, it works but with the following modifications =offset(G7;MATCH(3;G8:G26;);-5)
Wow u helped me a lot.
yg_be 3406Posts lundi 9 juin 2008Registration date ContributorStatus September 26, 2017 Last seen -
Glad to help, and, even better, glad to see that you understood it well enough to adapt it!
Alternative (just closer to what I had proposed, otherwise your formula is perfect):
=OFFSET(B8;MATCH(3;G8:G26;0)-1;0)
student123456 3Posts Sunday November 13, 2016Registration date November 13, 2016 Last seen -
The Result for =OFFSET(B8;MATCH(3;G8:G26;0)-1;0) is cell B12(EEEEEEEEEEEEE), i guess this will come in handy someday.
You made my work so much easier, thanks again and i am glad that i understood it quick