|With 4 "pairs", you could use a Nested IF in G4:|
=IF(A4="NV15", 1, IF(A4="XY27", 2, IF(A4= etc.
Format G4 as currency and the results will display as dollar values.
However, a more elegant solution would be to use VLOOKUP. Look it up in the Excel Help files.
Create a table of your pairs in e.g. B1:C4 and use something like:
=VLOOKUP(A4, $B$1:$C$4, 2, 0)
By using VLOOKUP you could simply change the table if your data or dollar values change and not have to edit the formula.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.