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
student123456 Posts 3 Registration date Sunday November 13, 2016 Status Member Last seen November 13, 2016 - Nov 13, 2016 at 04:37 PM
Related:
- How to find value from a column with unique random values
- Based on the values in cells b77 b81 ✓ - Excel Forum
- Based on the values in cells b77 ✓ - Excel Forum
- How to delete column in word - Guide
- Based on the values in cells b77 b81 c77 - Excel Forum
- Vba find column by name ✓ - Excel Forum
1 response
yg_be
Posts
23242
Registration date
Sunday June 8, 2008
Status
Contributor
Last seen
October 4, 2024
5
Nov 13, 2016 at 01:44 PM
Nov 13, 2016 at 01:44 PM
Try this formula :
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.
=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.
Nov 13, 2016 at 03:55 PM
Wow u helped me a lot.
Nov 13, 2016 at 04:25 PM
Alternative (just closer to what I had proposed, otherwise your formula is perfect):
=OFFSET(B8;MATCH(3;G8:G26;0)-1;0)
Nov 13, 2016 at 04:37 PM
You made my work so much easier, thanks again and i am glad that i understood it quick