Harlan,

I didnt dismiss the advice (blithely or otherwise). I actually did try
Bobs suggestion and received an error. In the end the error was mine, as I
had not noticed Bob had left off the 4th argument. For this I apologize. I
will strive to be as infallible as you in the future.

Nowhere in this string did I proclaim to be an expert on how a VLOOKUP
works, or anything else for that matter. If I were an expert I would have no
reason to be posting in this newsgroup.

I would like to thank you for taking time out of your busy life to peruse
this newsgroup and clarify issues for the less educated. Despite your reply
being presumptuous, insulting and rude; this issue is much clearer for me
now. It is very comforting to know when a novice like me reaches out for help
that there are fine dilettantes such as yourself providing the subject matter
expertise. Very eloquent and reassuring.

Maybe in the future you could provide those you decide to grace with your
wisdom with a modicum of respect. Whats the worst that could happen? Someone
may be appreciative and thankful? Neither happened in this case. Your Excel
skills may be finely tuned, but your people skills leave a lot to be desired.
Kudos to you.

My true thanks go out to Bob Phillips. You sir, are a gentleman and a
scholar. Maybe Harlan will glean a small sliver of your tact and
understanding. Thanks!


"Harlan Grove" wrote:

"fpd833" wrote...
No go, this wont work unless the QScore in ColD is an exact match to the
low
or high end of the range.

Wrong. With no 4th argument, VLOOKUP matches the largest value in the first
column of its 2nd argument less than or equal to its 1st argument. Try
reading online help for functions suggested by others before you blithely
dismiss them.

In the example I provided, the person received a QScore of 3.56
(ColD)....this is between 3.01 and 4.0 (ColA and ColB) so it should return
the number 4 from ColC in to ColE.

Why don't you just *TRY* Bob's formula? What's the worst that could happen
other than proving you don't know how VLOOKUP works?