Lookup using Multiple criteria in Excel/VBA

[arunt_28]

Hi All,

I'm trying to solve the below problem, Can any experts help me to solve it, Thank You In the below table, if i enter X,Y&Z i need the corresponding Node which is near to this X,Y& Z values. Example if Enter X= 8900, Y=1000,Z=1000, the output should be Node:2 Node X Y Z 1 1000 1000 1000 2 8800 1000 1000 3 16700 1000 1000 4 24500 1000 1000 5 1000 1000 10700 6 24500 1000 10700 7 1000 1000 20050 8 8800 1000 20050 9 16700 1000 20050 10 24500 1000 20050 11 1000 6000 1000 12 8800 6000 1000 13 16700 6000 1000 14 24500 6000 1000 15 1000 6000 10700 16 24500 6000 10700 17 1000 6000 20050 18 8800 6000 20050 19 16700 6000 20050 20 24500 6000 20050 <colgroup><col><col span="3"></colgroup><tbody> </tbody> <colgroup><col><col span="3"></colgroup><tbody> </tbody>

<colgroup><col><col span="3"></colgroup><tbody>
</tbody>

 

[Gary McMaster]

Welcome to the board!

I don't think you given enough info for us to help you.

Is it always just X that deviates from the values in the list or can the deviation be with Y and Z as well?
Can the deviation be in more than one of the 3 columns at the same time?
Are you trying to do this with formulas or VBA code?

At first glance, I would say sum X,Y,Z in column "E" and compare that to the sum of the X, Y, Z that you enter. That should narrow the list
substantially. Maybe if you subtract one sum from the other the smallest absolute value will be your solution. I guess it depends on the answers to the questions above.

Gary