formula
Assuming your list is in F1:G10, then put this formula in B1 and type the
code value in A1
=VLOOKUP(A1,F1:G10,2,FALSE)
Vaya con Dios,
Chuck, CABGx3
"Buttercup" wrote:
Please help me write a formula that will allow me to type any one of the
values in the left column in the key below in a blank cell and give a
numerical value that corresponds to key in the adjacent cell next to the
blank cell.
For example if I type GM in a blank cell I want the cell to the right to
give me 1.0. (Also in that same cell if I type any of the other items in the
column on the left I want it to give me the number that corresponds to it.
Here is part of the key (there are other items that will have corresponding
numbers ranging from 0 to 1.25):
GM 1.0
W4 1.0
D5 0.5
3M 1.25
4M 1.0
PO 1.0
RO 1.0
MSB 1.0
NICL 1.0
DPO 1.0
Thanks,
Buttercup
|