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

Hi

=IF(ISNA(VLOOKUP($E3,[ukm0604q.xls]disk!$E$2:$R$2218,11,0)),0,VLOOKUP($E3,[ukm0604q.xls]disk!$E$2:$R$2218,11,0))


--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )



"Heather O'Malley" wrote in message
. ..
Hello,

I am trying to use a look up to avoid a manual update of some trade
statistics – however when I look up a ref that is not within my lookup range
it gives the previous rows data.

For example, 04090000074 is within the data range and is correct but the 2
below are not 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,11))=TRUE,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