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.

How to find value from a column with unique random values
How to delete a column in word - Guide
Based on the values in cells b77 b88 - Excel Forum
Tweetdeck expand column - Guide
Vba select column by name ✓ - Excel Forum
Based on the values in cells b77 b81 c77 - Excel Forum

1 response

Answer 1 / 1

yg_be Posts 24281 Status Contributor 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.

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.

yg_be Posts 24281 Status Contributor 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)

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

Similar discussions

Why does our account keep randomly following additional users every few weeks?

help me to add particular cells

Clear cell contents based on value of another cell range using VBA

A random chat ALWAYS top of my facebook messages on desktop

Fill adjacent cell with number from text answer

Similar discussions

Subscribe To Our Newsletter!