Formula to get the value of a cell in closest proximity to the left of a cell

[cclark19]

Hello, I am trying to figure out how to have the cells lookup the value in closest proximity to the cells to the left of my desired cell. For example, how to have the 2 show up in the x position, how to have the 1 show up in the y position, and the 3 in the z. And if I was to continue to input new values to the left of the 2,1, and 3, if it would recognize the new values. Any help is appreciated!

[TABLE="width: 500"]
<tbody>[TR]
[TD]2
[/TD]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]x[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]y[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]z[/TD]
[/TR]
</tbody>[/TABLE]

 

[jtakw]

Re: Help to find formula to get the value of a cell in closest proximity to the left of a cell

Hi,

This will do what you want if your values are numeric:

Book1
	A	B	C	D	E	F	G	H
1	2	4	3					3
2	1	2						2
3	3	6						6
Sheet625

Cell Formulas
Range	Formula
H1	=LOOKUP(9.99999999999999E+307,A1:G1)

Formula copied down.
Column H will update as you enter additional values.

 

[cclark19]

Hello, I am trying to figure out how to have the cells lookup the value in closest proximity to the cells to the left of my desired cell. For example, how to have the 2 show up in the x position, how to have the 1 show up in the y position, and the 3 in the z. And if I was to continue to input new values to the left of the 2,1, and 3, if it would recognize the new values. Any help is appreciated!

[TABLE="width: 500"]
<tbody>[TR]
[TD]2[/TD]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]x[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]y[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]z[/TD]
[/TR]
</tbody>[/TABLE]

Perfect, thanks so much!

 

[jtakw]

You're welcome, welcome to the forum, thanks for the feedback.