Re: $$Excel-Macros$$ need help on finding the vales in attached sheet

Hi Paul, Thanks for your quick reply, However your suggested formula is not working correctly it shows "No Record Found" for all the records. Hence request you to kindly help me on this. Regards, On Sat, Jun 18, 2016 at 12:50 AM, Paul Schreiner wrote: > You're looking

Re: $$Excel-Macros$$ $$Help Required$$

use this: ={IFERROR(VLOOKUP($A3$1,CHOOSE({1,2},$M$13:$M$22&$O$13:$O$22,$N$13:$N$22),2,0),0)} *PJ * *MIS Analyst* *Greater Kailash-1, New Delhi.* *Instagram* *pj_sharma_* *Tweeter* *dude_sharma_pj**Facebook**