Fins closest larger and smaller to and input number from another sheet and copy entire row

[Obedan]

I do not have any experience with VBA coding and I need your help to start learning.

I have two different sheets, The first one include the input from the user and should get the output as well.

The second sheet has all the data.

The user should input two variables D and W in the first sheet , The W value is fixed and the user will choose it from drop down list.

The code should find 2 rows with the same input W value and closest larger and closest smaller with respect to the value of D. Then it should copy these entire rows from sheet 2 to sheet 1.

 

[Obedan]

Okay.. what you are getting in this case using my formula ?


Regards,
DILIPandey

I'm getting the first row of the second sheet.

 

[svendiamond]

Just add an IFERROR like this:

=IFERROR(yourFormulaHere,"")

 

[DILIPandey]

Will be helpful if you can explain your expected output vs what you are getting using an example.

Regards,
DILIPandey