Lookup problem when selecting zero

My lookup does not show the required results when select a zero value.

Basically I need 3 values (deposit Value) that returns 3 different conditions.

The Deposit values need to be a value as I need to work out the deposit in another part of the spreadsheet.

I have attached a sample which replicates the error.

Any help is appreciated to resolve this.

Hi g1972

The way that I might handle this is to give X11 a value of 30 and use this a s your deposit code in J1.

Regarding "another part of the spreadsheet" perhaps you could use an "if" statement something like if your result is 30, then use 0 instead?

Regards
Alastair