Lookup Function

[Dwayne Schuck]

I recently modified a friend's spreadsheet to make it more functional. As
usual, it was a "learn as you go" process.

I learned about the validation and lookup functions this time.

No problem with validation - I created a nice little drop down menu with 32
possible selections. Whatever is selected in this dropdown menu needs to
reference two other cells in a table. The two formulas I used are:

=lookup(c7,aa51:aa82,ab51:ab82)
=lookup(c7,aa51:aa82,ac51:ac52)

The problem I am having is that for 31 out of 32 choices it works perfectly.
For one and only one choice it doesn't work. For the 29th choice in the
table, aa79 it references ab80 and ac80.

Why would this function work correctly for 31 out of 32 possibilities?
Email me and I'll send a copy of the sheet.

Thanks.

Dwayne
(e-mail address removed)

 

[Bob Phillips]

LOOKUP expects the lookup_vector range (AA51:AA82 in your first example), to
be in ascending order. Are yours?

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Dwayne Schuck]

Bob, that solved the problem. Thanks.

LOOKUP expects the lookup_vector range (AA51:AA82 in your first example),
to be in ascending order. Are yours?

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)