Hello,

I am trying to use a look up to avoid a manual update of some trade statistics =E2=80=93=
however when I look up a ref that is not within my lookup range it gives the previous row=
s data.

For example, 04090000074 is within the data range and is correct but the 2 below are no=
t and should be zero but pick up the nearest references data.

My lookup formula is: IF(ISNA(VLOOKUP($E3,[ukm0604q.xls]disk!$E$2:$R$2218,1=
1))=3DTRUE,0,VLOOKUP($E3,[ukm0604q.xls]disk!$E$2:$R$2218,11))


04090000074 0 12300 0 0
04090000092 0 12300 0 0
04090000352 0 12300 0 0

Any help is appreciated.

Thanks