Excel VLookUp Problem

[vivienne3608]

Good morning,

I am hoping someone can help me with a problem I'm having in the attached spreadsheet.

I want excel in cell I5 to:

Look at the following 2 criteria: Group cell I2 and the Proposed Amount cell I4. Find those in the data table B3:E20 and return the appropriate Proposed Level from coloumn F.

Any formula ideas is appreciated.

Thank you

Vivienne

[XOR LX]

Hi.

Is the value in I3 not to be considered then?

Regards

[boopathiraja]

Hi, May be this

Please Login or Register  to view this content.

[samba_ravi]

=sumproduct((a3:a20=i2)*(b3:e20=i4)*(f3:f20))

[vivienne3608]

Hi,

Yes it is but I thought excel will know when it looks up the group and proposed amount that it is in that location anyway.

Thanks.

Hi.

Is the value in I3 not to be considered then?

Regards[/QUOTE]

[vivienne3608]

Hi,

The formulas from nflsales and boopathiraja both return a higher figure than is available from the Proposed Level column. You can change the stage to 2,3 or 4 and select a relevant Proposed figure to test that.

Thank you for trying.

Vivienne

[boopathiraja]

You mean this ?

Please Login or Register  to view this content.

[vivienne3608]

Thank you boopathiraja, that second formula works.

I really appreciate the time taken by those who tried to solve this issue for me.

Thank you.