Share via

Excel Lookup without sorting Table - Possible?

Anonymous
2015-06-17T13:19:28+00:00

Lookup requires that the table (lookup vector) be sorted by the lookup field (value).  Is there a method or other formula that does not require the table to be sorted first?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2015-06-17T14:33:54+00:00

    Could you use VLOOKUP with the argument of FALSE which does not require a sorted table?

    Gord

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Ashish Mathur 101.9K Reputation points Volunteer Moderator
    2015-06-18T00:09:51+00:00

    Hi,

    What exactly do you want to do?  Share the question and expected result.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2015-06-17T13:28:43+00:00

    Hi, yes Index/match look Debra web with videos and examples

    http://www.contextures.com/xlFunctions03.html

    Was this answer helpful?

    0 comments