Best way to cross-reference a numberic index

[Joah]

I have two variables that I wish to keep track of. One is hit dice, and the other is points. The column on the left is the hit dice which has an associate cost on the right. What is the best way for excel to reference the values to generate a cost?

1 1
2 2
3 4
4 5
5 6
6 7
7 8
8 10
9 13

Cheers,

[RobertMika]

What's the result shoudl be?

[zbor]

Here try this:

=LOOKUP(D6,{1,2,3,4,5,6,7,8,9},{1,2,4,5,6,7,8,10,13})

That can be shortened in this particula example as:

=LOOKUP(D6,ROW($A$1:$A$9),{1,2,4,5,6,7,8,10,13})

[Joah]

Thank you for your reply,

If I copy and paste this in the function ribbon of a cell it just prints "
=LOOKUP(D6,{1,2,3,4,5,6,7,8,9},{1,2,4,5,6,7,8,10,13})" in the cell (and does nothing).

hmm,

[Joah]

I am only two-days old ... with Excel heh heh, so yeah, but I very much appreciate this forum. I found my answer by searching vlookup function. Excel is nice as it has a menu system that a person can more or less follow.

Cheers,