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
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