Vlookup or Indext Match with 2 Criteria

[hardeep.kanwar]

Hi All,

Is there any way for get the Value in another Table or Sheet, Using Vlookup or Index match Function

Where the Criteria is More than 1

 

[JAMIR]

Hello Hardeep,

Please see the attached file.

Regards,

Zameer

 

[Mike H..]

Hi All,

Is there any way for get the Value in another Table or Sheet, Using Vlookup or Index match Function

Where the Criteria is More than 1

Hi,

Have a look at your workbook.

 

[hardeep.kanwar]

Hello Hardeep,

Please see the attached file.

Regards,

Zameer

Thanks Shaikh Saab

Kamal Kar diya aapne to, Thanks again

 

[JAMIR]

My Pleasure....


Zameer

 

[hardeep.kanwar]

Hi,

Have a look at your workbook.

omg, How should i Forget Sum product Function

Thanks a Lot Mike

 

[jeffreyweir]

I'd suggest using PivotTables, which are designed for this type of task. I always use PivotTables instead of SUMPRODUCT where I can, because SUMPRODUCT doesn't scale well over large data sets. (i.e. it is very resource intensive), and because PivotTables are easier for basic users to follow.