Excel query

Factual Questions
21

Lionne,

VLOOKUP is the way to go as you’ve discovered. And it MAY help with the companies being assigned a range of (bag?) numbers.

Research the use of the “range_lookup” parameter in VLOOKUP (it’s the FALSE in the fourth position). If set to TRUE, it will the matching row or an “approximate” match - in the table below a VLOOKUP(A1, Companies, 2, TRUE) where A1=2 will return “ABC”



 1  ABC
11  DEF
21  GHI

For this to work, the table must be sorted in ascending order.

22

[QUOTE=K364]
For this to work, the table must be sorted in ascending order.
[/QUOTE]

True, but also important to note is that it will find matches even where there aren’t supposed to be any.

For example, if Company A has 23 - 25, and Company B has 28 - 34, but nobody has 26 - 27, it will still return either Company A or Company B when 26 or 27 is entered (depending on the range_lookup setting).

If that’s acceptable, then that’s an even quicker way than what I proposed, but I didn’t get the impression that that would work for you, Lionne.

23

True, but you could put in dummy rows: “26 - INVALID”