L
LiAD
Can anyone tell me how to get the match and index functions to work for an
8x8 table?
So for example I would like the function to take a given text string ec for
example, search for its position in the first table, then look at the second
table and return the value the corresponds to the text string located in the
first box.
Examples - I ask the function to find the value corresponding to; ec the
function returns the value 99, for bh - 4, for ga- 78.
The text string to match is in cell m10, and the top left corner of the
tables begins in cell N10.
Tables below
a b c d e f g h
a aa ba ca da ea fa ga ha
b ab bb cb db eb fb gb hb
c ac bc cc dc ec fc gc hc
d ad bd cd dd ed fd gd hd
e ae be ce de ee fe ge he
f af bf cf df ef ff gf hf
g ag bg cg dg eg fg gg hg
h ah bh ch dh eh fh gh hh
a b c d e f g h
a 20 11 30 33 44 40 78 54
b 20 20 20 20 20 20 20 20
c 20 43 5 90 99 67 60 56
d 20 20 20 20 20 20 20 20
e 20 20 20 20 20 20 20 20
f 20 20 20 20 20 20 20 20
g 20 23 21 12 12 12 12 12
h 20 4 4 4 4 50 43 80
Anyone know? I can't figure out how to get match to look at tables rather
than columns.
Thanks a million
8x8 table?
So for example I would like the function to take a given text string ec for
example, search for its position in the first table, then look at the second
table and return the value the corresponds to the text string located in the
first box.
Examples - I ask the function to find the value corresponding to; ec the
function returns the value 99, for bh - 4, for ga- 78.
The text string to match is in cell m10, and the top left corner of the
tables begins in cell N10.
Tables below
a b c d e f g h
a aa ba ca da ea fa ga ha
b ab bb cb db eb fb gb hb
c ac bc cc dc ec fc gc hc
d ad bd cd dd ed fd gd hd
e ae be ce de ee fe ge he
f af bf cf df ef ff gf hf
g ag bg cg dg eg fg gg hg
h ah bh ch dh eh fh gh hh
a b c d e f g h
a 20 11 30 33 44 40 78 54
b 20 20 20 20 20 20 20 20
c 20 43 5 90 99 67 60 56
d 20 20 20 20 20 20 20 20
e 20 20 20 20 20 20 20 20
f 20 20 20 20 20 20 20 20
g 20 23 21 12 12 12 12 12
h 20 4 4 4 4 50 43 80
Anyone know? I can't figure out how to get match to look at tables rather
than columns.
Thanks a million