On 2 Aug, 15:50, Haxer wrote:
I am trying to do a simple lookup command. Or at least I thought it was
simple. I don't know how many items will be in column A but I do know that it
won't go past row 1000. This is what I am using:
=LOOKUP(V3,S3:S1000,A3:A1000)
I keep returning a 0 for the answer. If I change it so that it only looks at
cells that curently have data:
=LOOKUP(V3,S3:S10,A3:A10)
it works fine, problem being that more items will be added, and yes the
cells are sorted.
Can anyone tell me where I am making my mistake please?
Thank you for your time.

At face value, it should be fine - but you could create two
dynamically named ranges - for example


=Sheet1!$S$3:OFFSET(Sheet1!$s$2,COUNTA(Sheet1!$s$3 :$s$1200),0)

would give you a range that is as long as the data in S3:S1200, but
ONLY as long as the data