lookup

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

The standard LOOKUP function (vector) requires that "The values in
lookup_vector must be placed in ascending order: ...,-2, -1, 0, 1, 2, ...,
A-Z, FALSE, TRUE; otherwise, LOOKUP may not give the correct value. Uppercase
and lowercase text are equivalent."

This is not convenient for me. The values I have in lookup_vector must
remain unsorted.

Is there a way to do this?
 
Edit your formula and in the range box try typing false. This should return
what you are looking for.
 
There is no range_lookup for LOOKUP. You must be thinking of VLOOKUP.

The OP will need to use either VLOOKUP or a combination of INDEX/MATCH and
set the range_lookup/match_type to 0 for an EXACT match. If you're looking
for an approximate match if an exact match is not found then you'll have to
post more detail.

Biff
 

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

Lookups and the next smallest value 1
How do I get correct results when LOOKUP with calculated numbers 2
Lookup Function 1
Need to modify lookup function 0
Scrabble Value calculation for Welsh words 0
Using LOOKUP without values in ascending order 2
Match and Lookup 1
Using LOOKUP only if a value exists 5

Back
Top