VLOOKUP from 2 values rather than 1?

[gohan2091]

Hi,

I need to find out how to do this for work and I've been trying various things for the last 45 minutes to no avail. In this small example, I have a data table and a separate lookup table beside it. I want the lookup table to return values from the data table. The last columns value (G Comlumn) in the lookup table needs to be determined based on what's being entered in the first two columns (E and F).

Here is my formula for the last column of the lookup table:

=VLOOKUP(E4,A4:C30,3,FALSE)

I need it to consider BOTH the values in E4 and F4 before returning the value so I wrote this formula:

=VLOOKUP(E4&F4,A4:C30,3,FALSE)

but it comes back with an error. I also tried:

=VLOOKUP(E4/F4,A4:C30,3,FALSE)

but of course, it will divide E4 and F4 together...

To help explain what I need doing, I have uploaded an image below and a link to the xls file. Can anyone help? I am an experienced Excel user but I only perform simple tasks. The sooner someone can help, the better so please if you know how to help, please do.



http://rapidshare.com/files/413271653/VLOOKUP_Example.xls

 

[gohan2091]

Unfortunately, I am unsuccessful in my task.

The below formula:

=INDEX(C$4:C$30,MATCH(1,INDEX((A$4:A$30=E4)*(B$4:B$30=F4),0),0))

does work, however since my lookup table is full of merged cells, the formula breaks thanks for your help anyway, I appreciate it and if you have another suggestion, or would like me to send you the actual sheet so you can work your magic, I would be interested.