Report

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 04:37PM
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 
Helpful
+1
moins plus
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 - Nov 13, 2016 03:55PM
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.
Reply
yg_be 842Posts lundi 9 juin 2008Registration date December 8, 2016 Last seen - Nov 13, 2016 04:25PM
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)
Reply
student123456 3Posts Sunday November 13, 2016Registration date November 13, 2016 Last seen - Nov 13, 2016 04:37PM
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
Reply
Add comment

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!