Lookup Function for Non-Alphabetical

T

TKS_Mark

Is there an equivelant lookup function in Excel 2007 that doesn't care about
the order of the item it's looking up. Example: I want to look up "eggs" in
column 1 of a table and once I know which row that is, lookup the price from
column "unit price". However, I have all my groceries in that table sorted
alphabetically, and in the same table, the hardware items are also sorted
alphabetically in a different group. (Fictional example.) So if eggs are in
the lower group, my table will stop at something in the upper hardware group
instead of just giving me the price of eggs.

Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top