Hi,

I am currently using a lookup formula to look at 2 sets of data on 2 excel
pages. It works fine when looking at 2 or 3 cells, but when I expand the
formula to lookup a few thousand cells is automatically looks up the last
cell amount, not the cells overall.

ie
LOOKUP(A2,Sheet1!$B$3:$B$10000,Sheet1!$C$3:$C$1000 0) doesn't work

but LOOKUP(A2,Sheet1!$B$3:$B$5,Sheet1!$C$3:$C$5) works fine


Any suggestions would be much appreciated.

The data it's reading is a data import, but I have re-imported to make sure
their are no faults with that.

Thankyou

Fiona