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

try this
=LOOKUP("Sheet2!",Sheet1!$B$3:$B$10000,"Sheet1!$C$ 3:$C$10000,false")
--
Thanks
Suleman Peerzade


"Fiona" wrote:

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

Is your data sorted?

--
__________________________________
HTH

Bob

"Fiona" wrote in message
...
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

Thanks Bob, that must have been it, sorted both import so they matched and
all is fine now.

thanks again

"Bob Phillips" wrote:

Is your data sorted?

--
__________________________________
HTH

Bob

"Fiona" wrote in message
...
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

thanks Bob, I've sorted both imports the same way and it works now so that
must have been it.

Thanks again

"Bob Phillips" wrote:

Is your data sorted?

--
__________________________________
HTH

Bob

"Fiona" wrote in message
...
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