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:

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

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

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

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

Last edited: