Vlookup help
 

Hello all. At work, I have just started to use Excel and it has been
some time since I last used it. I'm having a bit of a problem with
vlookup.

I want to use vlookup to display a number value if the cell in question
contains a number that is 10 or below the number. This number will then
be multiplied by a percentage (so I'm presuming I could just put in
somewhere *10/100 to multiply the value by 10 percent?) The percentage
that it is multiplied by varies depending on weather or not the value
is below 10.

I really am stuck here, any help would be greatly appreciate. Even a
good link to a website that could explain what I am trying to do.

Thank you very much and take care


--
aliend
------------------------------------------------------------------------
aliend's Profile: http://www.excelforum.com/member.php...o&userid=25596
View this thread: http://www.excelforum.com/showthread...hreadid=390138

To see how to use VLOOKUP, watch the video clip on
http://www.auditexcel.co.za/lookupandreference.html . For what you are trying
to do, the range indicator needs to be TRUE. Make sure the table is sorted
properly. To see what can go wrong with VLOOKUP, watch the clips on
http://www.auditexcel.co.za/errors.html (Lookup Clip). Hope this is what you
wanted.

"aliend" wrote:


Hello all. At work, I have just started to use Excel and it has been
some time since I last used it. I'm having a bit of a problem with
vlookup.

I want to use vlookup to display a number value if the cell in question
contains a number that is 10 or below the number. This number will then
be multiplied by a percentage (so I'm presuming I could just put in
somewhere *10/100 to multiply the value by 10 percent?) The percentage
that it is multiplied by varies depending on weather or not the value
is below 10.

I really am stuck here, any help would be greatly appreciate. Even a
good link to a website that could explain what I am trying to do.

Thank you very much and take care


--
aliend
------------------------------------------------------------------------
aliend's Profile: http://www.excelforum.com/member.php...o&userid=25596
View this thread: http://www.excelforum.com/showthread...hreadid=390138