You're on the right track with Vlookup, you will probably need to set up a
few reerence tables by the sounds of things, but once you're done it's fairly
easy from there.
Check out the Excel pages at
www.nwarwick.co.uk for a simple tutorial on
Vlookup, this should get you started.
HTH
Neil
"Genie Bohn" wrote:
Is this possible?
I want to compare a number against 3 ranges and display a comment for the
range it fits into.
Example.
Let's say the number is 6
<4 - would display no comment
between 5 and 15 - would display the comments "standard"
15 would display no comment.
This is only one line of comparison. Moving down the worksheet the next
example might look like this.
Let's say the number is 147
<80 - would display no comment
between 81 and 125 - would display no comment
125 would display the comment "below standard"
I am very new at vlookup and no nothing of nested functions.
Any help would be graciously accepted. TIA