R Rahul Mishra Member Sep 4, 2014 #1 i upload file excel file so need help for ans but i did some mistake i wrote noida but it is only A Attachments Question.xls Question.xls 33.5 KB · Views: 12
Khalid NGO Excel Ninja Sep 4, 2014 #2 Hi Rahul, See the attached file I have used simple VLOOKUP function. =VLOOKUP($E$19,$A$5:$T$13,3,FALSE) Attachments Question-2.xls Question-2.xls 27.5 KB · Views: 3
Hi Rahul, See the attached file I have used simple VLOOKUP function. =VLOOKUP($E$19,$A$5:$T$13,3,FALSE)
Hui Excel Ninja Staff member Sep 4, 2014 #3 See attached Note the 2 included Drop down's Attachments Question.xls Question.xls 34.5 KB · Views: 8
Somendra Misra Excel Ninja Sep 4, 2014 #4 Duplicate post @ http://chandoo.org/forum/threads/how-to-find-data-with-match.18776/ Regardsm