Lookup formula

[Fiona]

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$10000) 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

 

[Suleman Peerzade]

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

 

[Bob Phillips]

Is your data sorted?

 

[Fiona]

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

thanks again

 

[Fiona]

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

Thanks again