Hi,

I have struggled with this all day and was not able to pinpoint the
problem.

I have a table for poker odds that I have created for texas holdem. It
has the first hole card, by second hole card with probabilities wo win
the hand with those two cards.

Pot equity versus hands that have greater than 32% pot equity against a
random hand (Random hand). It looks like this:                       
    A    K    Q    J    T    9    8    7    6    5    4    3    2    Suited
A    0.852    0.6705    0.6621    0.654    0.646    0.6278    0.6194    0.6098    0.5991    0.5992    0.5903    0.5822    0.5738   
K    0.6532    0.824    0.634    0.6257    0.6179    0.5999    0.5831    0.5754    0.5664    0.5579    0.5489    0.5406    0.5321   
Q    0.6443    0.6146    0.7993    0.6026    0.5947    0.5766    0.5602    0.543    0.5361    0.5277    0.5186    0.5102    0.5017   
J    0.6356    0.6057    0.5814    0.7747    0.5753    0.5566    0.5402    0.5233    0.5061    0.4999    0.4907    0.4823    0.4738   
T    0.6272    0.594    0.573    0.5529    0.7501    0.5403    0.5233    0.5064    0.4894    0.4722    0.4653    0.4569    0.4484   
9    0.6077    0.5781    0.5536    0.5325    0.5153    0.7206    0.508    0.4912    0.4743    0.4572    0.4386    0.4326    0.4242   
8    0.5987    0.5602    0.536    0.5149    0.4972    0.481    0.6916    0.4794    0.4624    0.4455    0.427    0.4087    0.4027   
7    0.5884    0.5519    0.5177    0.4968    0.4791    0.463    0.4505    0.6624    0.4537    0.4368    0.4185    0.4004    0.3816   
6    0.5768    0.5422    0.5102    0.4784    0.461    0.4449    0.4324    0.4232    0.6329    0.4313    0.4133    0.3953    0.3767   
5    0.577    0.5331    0.5012    0.4718    0.4425    0.4267    0.4143    0.4051    0.3994    0.6033    0.4145    0.3969    0.3785   
4    0.5673    0.5233    0.4913    0.4619    0.435    0.4067    0.3947    0.3855    0.3801    0.3816    0.5702    0.3864    0.3683   
3    0.5585    0.5143    0.4822    0.4528    0.426    0.4002    0.3748    0.366    0.3608    0.3627    0.3515    0.5369    0.3598   
2    0.5493    0.5051    0.473    0.4435    0.4169    0.391    0.3683    0.3458    0.3408    0.3429    0.332    0.323    0.5033   
Offsuit                                                       
I want to create a lookup that finds the value in column "A" and row
"K" for example.

My problem is that the lookup works great for hands that are composed
of letters (for example Ace King = AK). But the formula returns errors
for hands that have numbers in them (for example Ace Nine = A9).

I get a #N/A error.

I'm stumped! Please help!

Jeff