W webmax Member Feb 13, 2014 #1 Hi Please find the attached file and kindly provide the formula Attachments formula reqd.xlsx formula reqd.xlsx 8.1 KB · Views: 5
N NARAYANK991 Excel Ninja Feb 13, 2014 #2 Hi Shahul , Try this : =VLOOKUP($G$3,$E$9:$G$11,MATCH($E$3,$F$8:$G$8,0)+1,FALSE) Narayan