Lookup formula

F

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
 
S

Suleman Peerzade

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

Fiona

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

thanks again
 
F

Fiona

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

Thanks again
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top