Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Using Vlookup in chart form
I have a spreadsheet project for my computer class....and I need help on
using Vlookup on a chart. The Chart is as follows: Credit Score Area Code 300 400 500 114 3% 4% 5% 113 112 You get the idea....anyways, basically what I'm trying to do is get the %(which will be a discount %) that matches the credit score and area code. I know I need to use Vlookup, but I'm having trouble getting it to work. Do i need to use more than one lookup formula all in one??? |
#2
|
|||
|
|||
If you know the credit score, you could use =vlookup().
=vlookup(a1,sheet2!a:d,3,false) If A1 contains the area code and you wanted the credit score for 400 (third column in that range). But if you don't know the credit score, you could use =index(Match()). You could look at Debra Dalgleish's site: http://www.contextures.com/xlFunctions02.html (for =vlookup()) and http://www.contextures.com/xlFunctions03.html (for =index(match())) For more info. ashley k wrote: I have a spreadsheet project for my computer class....and I need help on using Vlookup on a chart. The Chart is as follows: Credit Score Area Code 300 400 500 114 3% 4% 5% 113 112 You get the idea....anyways, basically what I'm trying to do is get the %(which will be a discount %) that matches the credit score and area code. I know I need to use Vlookup, but I'm having trouble getting it to work. Do i need to use more than one lookup formula all in one??? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Activating a Chart object | Charts and Charting in Excel | |||
copying chart Excel into a vb form | Charts and Charting in Excel | |||
Urgent Chart Questions | Excel Discussion (Misc queries) | |||
Urgent Chart Assistance Requested | Excel Discussion (Misc queries) | |||
How do I go from "Chart View" to "Pivot Table Form" in a Pivot ta. | Excel Discussion (Misc queries) |