VLookup

[acsell]

Hello, please could someone help me with vlookup. I've read different
articles, including the one on this site but havn't understood them
that well. I've attached an image of what I am trying to do. I've named
the table in the top right (discount) to DTable. I would like the
formula to look in there so that when someone enters a discount in e.g.
"discount 1" the cell below (discount=) displays the percentage that
"discount 1" is equal to.

thank you, acsell

File Attached: http://www.exceltip.com/forum/attachment.php?postid=302619 (vlookup.jpg)

 

[Earl Kiosterud]

acsell,

It appears that your attachment (attachments not allowed in these text
groups) has been summarily snatched from your post. Give the formula with
the VLOOKUP, the table (and its location), and we can help.

 

[acsell]

I've put a hyperlink to the picture below. If it doesn't work then it
can be found here-
http://doxeyramblers.50g.com/vlookup.jpg

This is the lookup I'm using but I know it's worng -
=VLOOKUP(J2:J4,DTable,2)



[image: http://doxeyramblers.50g.com/vlookup.jpg]

http://doxeyramblers.50g.com/vlookup.jpg

 

[acsell]

sorry, that didn't seem to work, try here-

http://doxeyramblers.50g.com/vlookup.htm

 

[Max]

Assume range I2:J4 is named: DTable

Put in E13: =VLOOKUP(TRIM(E11),DTable,2,FALSE)

 

[acsell]

Thanks alot for that

 

[Max]

you're welcome! cheers.