tough if then problem

[Dockta]

Hi all, I have a long list of codes and each of these codes correlates to a monetary value. I have been trying to use the if/then function but my problem is that the codes are alpha-numeric so it keeps thinking that it is a cell:

ie
Code Value
A085 $30
Z080 $20
K123 $50

I have all the codes listed and am hoping to automatically enter the Value, when I enter =if(A1=A085,30) it always says false because cell A1 never equals cell A85.

Any help in how to get around this would be amazing.

Cheers,

DL

[Norie]

Use VLOOKUP.

[Dockta]

But the problem i'm having is that excel recognizes A085 as a cell and not a code.

[Dockta]

Never mind, I understand what you mean now!! thanks

[FDibbins]

wrap the A085 in "" "A085"