vlookup erroe

[employee]

I have the following information

A B C D
E
1 Hyperion Account Job Workcode Balance
2 OP231 410100 30099006 COURI 300
3 OP232 410200 30099001 COURI 400
4 OP235 410100 30099009 COURI 100

I want the VLOOKUP to pick up the value (Balance) for COURI (workcode) when
the (Job) is 30099006.

Thanks

 

[Max]

One way to tackle the multi-criteria ..
Your source data as posted is within A1:E10, data from row2 down
Workcode/Job inputs placed in H1:H2 eg: COURI, 30099006
In H3, normal ENTER to confirm will do:
=INDEX(E2:E10,MATCH(1,INDEX((D210=H1)*(C2:C10=H2),),0))
Success? Eternalize it, hit the YES below