Which Formula/Rule to use to complete the following issue that I have:

Occasional Visitor
If H115 Shows a value automatically entered from another TAB, I need L122 to choose a value in either H119 or H122 or H125 or H128 as they have different values based on the Values in G119,G122,G125,G128. Example, I have a value automatically added in H115 from another TAB, in this case it is 3.  Values are as follows: G119= 3,  G122=5,  G125=12,  G128=15 (These are set values as well as H119=25, H122=11,5,  H125=4,5,  H128=3). I want L122 to choose any of the H cells, if H115 matches the specific G cell of similar value or close to similar value. I really hope this makes sense.
1 Reply


How to find closest or nearest value (number or text string) in Excel?

Supposing you have a list of numbers in a column, and now you are required to find out the closest or nearest value to a given value from the list of numbers.

How do you deal with it?

Actually, you can find closest value or nearest value in Excel with following steps in the upper link.


Additional information:

Welcome to your Excel discussion space!


Hope I could help you with these information / links.



I know I don't know anything (Socrates)