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