Index and Match Question

[chastst]

I have a table that contains various data:

WO# Status Activity Est Hrs
101000 R 1 2
101001 A 1 1
101001 R 2 3
101002 A 1 4

etc.

On another sheet, I would like to enter the WO# and Activity# in seperate columns and retrieve the Est Hrs i.e. for 101001 act 1 return 1 and 101001 act 2 return 3, etc. All WO# and Activity# combinations are unique.

Can someone help me with the formula?

TIA

 

[fairwinds]

Hi,

Try:

=LOOKUP(2,1/((A2:A5=F4)*(C2:C5=G4)),D2:D5)

This will give you last occurance where both conditions match.

Book1
	A	B	C	D	E	F	G	H
1	WO#	Status	Activity	Hrs
2	101000	R	1	2
3	101001	A	1	1
4	101001	R	2	3		101001	2	3
5	101002	A	1	4
Sheet2

 

[chastst]

Thanks - worked exactly as I wished