How to find value from a column with unique random values

Solved/Closed
student123456 Posts 3 Registration date Sunday November 13, 2016 Status Member Last seen November 13, 2016 - Nov 13, 2016 at 07:21 AM
student123456 Posts 3 Registration date Sunday November 13, 2016 Status Member Last seen November 13, 2016 - 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.

1 response

yg_be Posts 22711 Registration date Sunday June 8, 2008 Status Contributor Last seen April 21, 2024 5
Nov 13, 2016 at 01:44 PM
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.
1
student123456 Posts 3 Registration date Sunday November 13, 2016 Status Member Last seen November 13, 2016
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.
0
yg_be Posts 22711 Registration date Sunday June 8, 2008 Status Contributor Last seen April 21, 2024 5
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)
0
student123456 Posts 3 Registration date Sunday November 13, 2016 Status Member Last seen November 13, 2016
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
0