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

student123456 3 Posts Sunday November 13, 2016Registration date November 13, 2016 Last seen - Nov 13, 2016 at 07:21 AM - Latest reply: student123456 3 Posts Sunday November 13, 2016Registration date November 13, 2016 Last seen
- Nov 13, 2016 at 04:37 PM
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.
See more 

4 replies

Best answer
yg_be 5816 Posts Sunday June 8, 2008Registration dateContributorStatus June 22, 2018 Last seen - Nov 13, 2016 at 01:44 PM
1
Thank you
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.

Thank you, yg_be 1

Something to say? Add comment

CCM has helped 1818 users this month

student123456 3 Posts Sunday November 13, 2016Registration date November 13, 2016 Last seen - Nov 13, 2016 at 03:55 PM
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 5816 Posts Sunday June 8, 2008Registration dateContributorStatus June 22, 2018 Last seen - Nov 13, 2016 at 04:25 PM
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 3 Posts Sunday November 13, 2016Registration date November 13, 2016 Last seen - Nov 13, 2016 at 04:37 PM
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