Contact US

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Reverse lookup?

Reverse lookup?

Reverse lookup?

I have a list of (hundreds of) colors with the numbers we have assigned to them such as:

100n     Light red
101n     metallic blue
102n     transparent red

I created a lookup so that a user can type in a number to see what color it is assigned. I would now like to be able to type in a base color such as "red" and get a list of all possible color numbers (light red, met. red, bright red, etc, etc).

Is there a built in function(s) that I can use to do this? I am fairly comfortable writing VBA code, but I don't want to reinvent the wheel (unless of course there are lots of value added features and high margins - oops got caught up in the marketing spirit).

RE: Reverse lookup?

A pivot table would allow the data association to be reversed...


RE: Reverse lookup?

Thank you for your post. However, after looking through the help files and experimenting with a pivot table, I am unable to get the result that I would like. Assume the numbers are in column A and the descriptions are in column B. If the user types "red" into the input cell, I would like a list of all entries that have "red" somewhere in the description (say numbers in col C and descriptions in col D).

Thank you for the idea, pivot tables are new to me so it is quite possible that I am using it incorrectly. I will dig a little deeper into the help files to learn what I can. In the mean time any and all ideas are welcome!

RE: Reverse lookup?

Will the autofilter function work?

RE: Reverse lookup?

Make a data base with numbers (column A) and colors (column B).
Highlight complete database and select Data/AutoFilter.
Dropdown arrows appear in each column.
Select the one on color and then select custom.
In box select equals to and then in the box to the right  type either * red or red * depending on what you want sorted.
Alternately select ends with or begins with and then type red in second box.    

RE: Reverse lookup?

Thank you melone and aviat! It works wonderfully. Stars for both of you.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members! Already a Member? Login


Close Box

Join Eng-Tips® Today!

Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.

Here's Why Members Love Eng-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close