Hi, I'm having trouble this one out.
Normally I would just use {=INDEX(A:A,MATCH(J4&K4,D:D&E:E,0))} to return the value I'm looking for to cells at column N.
However, values from J and K aren't exactly equal to values from columns D and E. They have about a less than 1% difference.
Any way to still make excel return a value if the criteria checks are within a given tolerance? Say 1% in this case. If it can't find a value within 1%, it just returns a #N/A or some error.
I've been fiddling with regular excel functions, but i figured maybe there's an answer using VBA.
First time asking here so please forgive me
Capture.JPG
Bookmarks