I have a sheet with values in "X" values in A2:A300 and "Y" values in B1-CC1. I would like to have an inputbox to input the x, y value and have the corresponding cell selected.
Example:
Input- .20, 2.25
Result- Cell E7 is selected
What would be even better is if the inputbox would round up or down if the numbers input were not exactly the same as the ones listed. But if thats not possible I would be happy with just a solution to the top one.
Example:
Input- .215, 2.247
Result- Cell E7 is selected
Bookmarks