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 for a function like:
> =
use this:
={IFERROR(VLOOKUP($A3&C$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** www.facebook