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.