Thread: Vlookup help
View Single Post
  #1   Report Post  
aliend
 
Posts: n/a
Default 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