brianclay111
New Member
 Joined
 Sep 6, 2020
 Messages
 9
 Office Version

 365
 Platform

 Windows
Hi! so here I took the first column and took out the letters at the beginning and the numbers at the end. On column F the multiples were taken out. Now I have 2 different values for each row in column G and H. AAU for example has 169.84 in G and 168.3321 in H. I would like to compare the list in F to list C. For example AAU comparing it to list C, there are 4 AAU's in list C. I would like to compare the first number of AAU which is 169.84 to all the numbers in the D column that matches with the AAU's. 2.5, 2.5, 5, 5. and It would match to the closest number which is 5 and it would write the 5 in column I. The same needs to be done for column H, which would be written in column J.
Thank You!