# Index and Match Question

#### chastst

##### New Member
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

### Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce
Hi,

Try:

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

This will give you last occurance where both conditions match.
Book1
ABCDEFGH
1WO#StatusActivityHrs
2101000R12
3101001A11
4101001R2310100123
5101002A14
Sheet2

Thanks - worked exactly as I wished

Replies
5
Views
2K
Replies
7
Views
264
Replies
7
Views
710
Replies
10
Views
513
Replies
2
Views
236

1,221,384
Messages
6,159,544
Members
451,571
Latest member
Qwissy

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back