table formula needed??

[Erik]

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 match the column
A1 word .. then enter the number located in column B1
that is linked to that word..

Ive tried many formulas but no luck, do you have a formula
that could make this work for me.. Thank you

 

[JE McGimpsey]

One way:

Assume your lookup value (e.g., "OH1"), is entered in D1. Then:

=VLOOKUP(D1,A1:B5,2,FALSE)