Help required with Formula

  • Thread starter Thread starter Ajay Kumar
  • Start date Start date
A

Ajay Kumar

I have a spread sheet with the following information:

Sheet1 has current requirements:

Position Technology Location

Sr. TA .NET US
Sr. TA VB/COM India
Developer JAVA Europe

sheet 2 has the people for these requirements:

Role Technology Location Name
Sr. TA VB/COM India XXX
Developer .NET India YYY
Developer VB/COM India ZZZ

I want to find out the Number of Sr. TA for VB/COM in
india to be displayed in sheet 1 next to the requirement.

Can somebody please help

thanks
ajay
 
Hi
try the following array formula (entered with
CTRL+SHIFT+ENTER) in cell D2 on your first sheet (this
should be the first data row)
=INDEX('sheet2'!$D$2:$D$100,MATCH(1,('sheet2'!
$A$2:$A$100=A2)*('sheet2'!$B$2:$B$100=B2)*('sheet2'!
$C$2:$C$100=C2),0))
and copy this down
 
Back
Top