Re: Need help with Excel..
Yes, Vlookup is the ticket here, try:
=VLOOKUP(C8,$C$4:$D$6,2,FALSE)
"=VLOOKUP(" name of function
"C8" cell whose value is being looked up
"$C$4:$D$6" the table of values being consulted
"2" we want the second column
"FALSE" here I want an exact, not an approximate, result
(Dollar signs mean the range stays constant if you fill down the function. Here you won't need them.)
In your example, you would create a 2*3 table of values
1 273
2 427
3 712
say the table is in the range C4 thru D6
Cell C8 : AGE
In this cell you enter 1,2,3 or whatever
Cell C10 : PRICE
Your vlookup formula goes in cell C10
I use Excel spreadsheets all the time in games, creating tables for reference&
|