Formula help

  • Thread starter Thread starter Erik
  • Start date Start date
E

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
 
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
Click to expand...

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.
 
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
 
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
 
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
Click to expand...
corresponding values in a range,
 
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
Click to expand...
...

Right. Use VLOOKUP.
 
i tried vlookup.. cant get the formula right??? any
wording ideas on how to word the formula..
 
i tried vlookup.. cant get the formula right??? any
wording ideas on how to word the formula..
Click to expand...
...

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).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

table formula needed?? 1
Help with SUMPRODUCT & converting date to value 1
Four macros, one main output 2
Need help with formula looking for dual lookups 3
Please help! Macros 1
Nesting IF/OR Statement 14
Formula Based on the cell its in 3
Excel drag down formula not working good.. 1

Back
Top