Is there an easy way to do this? I'm trying to take the list from column D and compare each cell to the elements in column A, then compare the number next to column D(column E) and match that number with the closest match in column B that is in that group and write it to column G. I also need to do the same thing for column F. For Example, dog column E is 53, in column A there are 4 rows with dog and the closest number to 53 is 35, so the 35 would go in G2. Then the same for column F but would get written in H2 and so on.
I'm a little stumped on this one, any help would be appreciated. Thank You.