Meet the Other Phone. A phone that grows with your child.

Meet the Other Phone.
A phone that grows with your child.

Buy now

Please or to access all these features

Geeky stuff

I need a (mega) Exel geek

11 replies

SlightlyMadSweet · 11/05/2008 22:15

I want to use a lookup table

Does my list in column 1 need to be alphabetical?

OP posts:
Tartanmam · 11/05/2008 22:22

Don't think, mine are all numerical in either ascending or descending order but i don't think they have to be 'in order'

Could be wrong though

Tartanmam · 11/05/2008 22:22

oops, don't think so.

SlightlyMadSweet · 11/05/2008 22:26

The only reason that I sak is that the couple of sites I have seen have said that you need to be in alpha numerical order....something to do with Excel stopping looking when it gets to teh right point in teh table.....or returning the closest entry.

As I say my Blossom hill is inhibiting my interpretation.

OP posts:
twelveyeargap · 11/05/2008 22:28

If you use the "lookup" formula, then the list needs to be sorted in ascending order.

If your list isn't sorted, then use vlookup or hlookup.

SlightlyMadSweet · 11/05/2008 22:28

I was going to use vlookup (i thin)

OP posts:
Kevlarhead · 12/05/2008 20:19

YES if:

You use MATCH with 1 or -1 as search types.

You use VLOOKUP with TRUE (i.e. if it can't find an exact match it'll find the the nearest value.)

NO if:

You use MATCH with 0 as search type.

You use VLOOKUP with FALSE (i.e. exact matches only)

I never use Lookup, so couldn't tell you about that...

StealthPolarBear · 17/05/2008 15:18

i only ever use vlookup with false, don't think it needs to be sorted for that

fourlittlefeet · 19/05/2008 10:42

they ALWAYS need to be sorted or it won't work! (and use false)

littlelapin · 19/05/2008 10:49

This reply has been deleted

Message withdrawn at poster's request.

fourlittlefeet · 19/05/2008 22:06

I thought someone might say that

its never worked for me when not sorted though!

littlelamb · 19/05/2008 22:09

littlelapin (i am not stalking you) someone pointed out last week that we are both small creatures. I programme excel for a living too. Are you actually me???

New posts on this thread. Refresh page