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
Bookmarks