D
david
if i have the following table:
column 1 column 2
row 1 F 2
row 2 G 6
row 3 L 8
i want to write an if/then statement in a cell (call it
cell Z, not a cell as shown above) that will look at a
certain cell (also a different cell, call it Y) and if it
finds an F in cell Y, will look at the above table and
put a 2 (the corresponding number to the letter F as
indicated above) in cell Z, if it sees a G, put a 6 in
cell Z, etc.
does anyone know how to do this or know the name of the
function that can do this?
thank you in advance.
david
column 1 column 2
row 1 F 2
row 2 G 6
row 3 L 8
i want to write an if/then statement in a cell (call it
cell Z, not a cell as shown above) that will look at a
certain cell (also a different cell, call it Y) and if it
finds an F in cell Y, will look at the above table and
put a 2 (the corresponding number to the letter F as
indicated above) in cell Z, if it sees a G, put a 6 in
cell Z, etc.
does anyone know how to do this or know the name of the
function that can do this?
thank you in advance.
david