Lookups

[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

 

[Peo Sjoblom]

=VLOOKUP(LookupValue,A:B,2,0)

no need to sort anything


--


Regards,


Peo Sjoblom

 

[Gord Dibben]

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

Select columns A:C and sort by priority.


Gord Dibben MS Excel MVP