Lookups

  • Thread starter Thread starter dmitry
  • Start date Start date
D

dmitry

Hi,

I'm not having much luck with doing a simple lookup. For simplicity
sake, I have a table with three columns: name (A), duration (B), and
priority (C). The table is sorted (and constantly resorted) by
priority. I need to be able to look up duration values (in B) by
their names (in A). My understanding is that LOOKUP requires the
lookup array to be sorted by the lookup column. In my case, I don't
and can't have it sorted that way, so the function returns invalid
values. Is there a way to do this?


Thanks
Dmitry
 
Use the formula =VLOOKUP(A2,$A$2:$C$20,2,FALSE)

Select columns A:C and sort by priority.


Gord Dibben MS Excel MVP
 
Back
Top