Formula help

[Erik]

IM TRYING TO MAKE A FORMULA THAT CAN LOOK FOR TEXT AND
AUTOMATICALLY CHANGE IT TO A NUMBER.

FOR EXAMPLE ( IF CELL L6 ="LH',THEN INSERT "0.10" IF CELL
L6="OH1" THEN INSERT "0.15"...ETC

 

[Harlan Grove]

IM TRYING TO MAKE A FORMULA THAT CAN LOOK FOR TEXT AND
AUTOMATICALLY CHANGE IT TO A NUMBER.

FOR EXAMPLE ( IF CELL L6 ="LH',THEN INSERT "0.10" IF CELL
L6="OH1" THEN INSERT "0.15"...ETC

First, don't use all caps. It's considered shouting, and should only be used for
emphasis.

Enter a table of your letter codes and their corresponding values in a range,
then use VLOOKUP. If A1:B2 contained

LH 0.10
OH1 0.15

then VLOOKUP("LH",A1:B2,2) would return 0.10. Read about VLOOKUP in online help.

 

[Gord Dibben]

ERIK

=IF(L6="LH",0.1,0.15)

The ...ETC you will have to figure out for yourself or post back with more
detail. Like how many arguments do you have.

Perhpas an LOOKUP formula would serve you better.

Gord Dibben Excel MVP

 

[Guest]

Sir,

Here is the table that im making..
A1 B1
LH 0.10
OH1 0.15
OH2 0.20
EH1 0.30
EH2 0.40

what i need is for the cell to look and see if a word in
coulmn A1 matched then is it does then enter numbers
located in column B1 into that cell

 

[Guest]

Sir,

Here is the table that im making..
A1 B1
LH 0.10
OH1 0.15
OH2 0.20
EH1 0.30
EH2 0.40

what i need is for the cell to look and see if a word in
coulmn A1 matches.. then if it does then enter numbers
located in column B1 into that cell

-----Original Message-----
...

First, don't use all caps. It's considered shouting, and should only be used for
emphasis.

Enter a table of your letter codes and their

corresponding values in a range,

 

[Harlan Grove]

Here is the table that im making..
A1 B1
LH 0.10
OH1 0.15
OH2 0.20
EH1 0.30
EH2 0.40

what i need is for the cell to look and see if a word in
coulmn A1 matches.. then if it does then enter numbers
located in column B1 into that cell

...

Right. Use VLOOKUP.

 

[Guest]

i tried vlookup.. cant get the formula right??? any
wording ideas on how to word the formula..

 

[Frank Kabel]

Hi
see the following site for some good examples:
http://www.mvps.org/dmcritchie/excel/vlookup.htm

 

[Harlan Grove]

i tried vlookup.. cant get the formula right??? any
wording ideas on how to word the formula..

...

Show us the formula you tried to use and tell us what the incorrect result was.
If you make us guess what you've tried, you're going to wait a long time to get
answers (if you ever do).