VLookup


A

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)
 
Ad

Advertisements

E

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.
 
M

Max

Assume range I2:J4 is named: DTable

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

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VLOOKUP 1
Vlookup 5
vlookup 10
Vlookup 4
VLOOKUP 3
VLookup 5
vlookup 1
Vlookup 2

Top