C CMLET Member Mar 30, 2019 #1 Hi everyone, need some help with a formula. The Sample1 Column A contains 125 values in 6500 rows. Column D contains only the 125 values sorted, and Column E are corresponding values. The expected results (manually entered in B1:B4) . Attachments Sample1.xlsx 66.2 KB · Views: 11
Hi everyone, need some help with a formula. The Sample1 Column A contains 125 values in 6500 rows. Column D contains only the 125 values sorted, and Column E are corresponding values. The expected results (manually entered in B1:B4) .
B bosco_yip Excel Ninja Mar 30, 2019 #2 In B1, enter formula and copied down : =IFERROR(VLOOKUP(A1,D$1:E$125,2,0),"") Regards Bosco
