M manoj_th Member Jan 27, 2017 #1 Hello Everyone, Need formula in E4 & E5 cells. Please find the attached excel file. Thanks in advance. Manoj Attachments Book1.xlsx 9.3 KB · Views: 7
Hello Everyone, Need formula in E4 & E5 cells. Please find the attached excel file. Thanks in advance. Manoj
B bosco_yip Excel Ninja Jan 27, 2017 #2 E4, formula copy down to E5 : =INDEX(B$4:B$15,MATCH(E6,A$4:A$15,0)) Regards
A AVK Active Member Jan 27, 2017 #3 This also try in another option "E4" =VLOOKUP($E6,$A$4:$B$15,2,0) "E5" =VLOOKUP($E7,$A$4:$B$15,2,0)
