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.

=VLOOKUP("eggs",A1:B100,2,0)


"TKS_Mark" wrote:

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.

Excellent!

"Teethless mama" wrote:

=VLOOKUP("eggs",A1:B100,2,0)


"TKS_Mark" wrote:

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.

You're Welcome!

"TKS_Mark" wrote:

Excellent!

"Teethless mama" wrote:

=VLOOKUP("eggs",A1:B100,2,0)


"TKS_Mark" wrote:

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.