Hi,

What shall I do to make lookup leaves the cell without a match as blank and
not doublicating the value of the last matched cell?
--
tarig

You did not specify details on your lookup, but here are a couple of ideas

If you only want to use exact matches you could just check for an exact
match first and if not found use "" like this

If(iserror(match("A",A1:A20,0)),"",Lookup("A",A1:2 0))
This works for numbers and text


If you are using numbers and only want to return blank if the number is
greater than the last number use this

if(300max(A1:A20),"",Lookup(300,a1:a20))
This does not work for text.

--
If this helps, please remember to click yes.


"Tarig" wrote:

Hi,

What shall I do to make lookup leaves the cell without a match as blank and
not doublicating the value of the last matched cell?
--
tarig