Using Vlookup in chart form

[Guest]

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]

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.