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 a

=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

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" wrote in message
...
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 a

=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

Bob, that solved the problem. Thanks.


"Bob Phillips" wrote in message
...
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" wrote in message
...
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 a

=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