Working excel formula is as follows:
{=INDEX(G12:G73,MATCH(MIN(ABS(G12:G73-G10)),ABS(G12:G73-G10),0))}
Please keep in mind that the lest row will vary. In this case, it's 73, but that will change daily so that part has to be dynamic. The data will always begin with row 12 and the numbers will always be compared to the number in cell G10. Column G is static as well.
Below is my first attempt that obviously failed.
I'm thinking there might be a better approach than all of these WorksheetFunctions so I thought I'd ask your expert opnion. Thanks in advance!Please Login or Register to view this content.
Bookmarks