Re: $$Excel-Macros$$ Re: VLLOKUP IS NOT WORKING

2012-05-30 Thread Anil Gawli
share your data with us . Regards, Gawli Anil On Wed, May 30, 2012 at 6:09 PM, Rahul Arora wrote: > U can use index match formula.. > > > > =INDEX(Sheet1!$B$3:$G$20,MATCH(Sheet2!E3,Sheet1!$E$3:$E$20,0),MATCH(Sheet2!$G$2,Sheet1!$B$2:$G$2,0)) > > > > Regards, > Rahul > > > > > > On Wednesday, May

$$Excel-Macros$$ Re: VLLOKUP IS NOT WORKING

2012-05-30 Thread Rahul Arora
U can use index match formula.. =INDEX(Sheet1!$B$3:$G$20,MATCH(Sheet2!E3,Sheet1!$E$3:$E$20,0),MATCH(Sheet2!$G$2,Sheet1!$B$2:$G$2,0)) Regards, Rahul On Wednesday, May 23, 2012 5:18:15 PM UTC+5:30, Mitr wrote: > > Hi Experts >> >> >> VLOOKUP is not working in attached file, can anyone help