Need help ~ Newbie

[sricomm]

I am a newbie and need help badly to solve some calculation here .. please comment and help me .. thanks .

The value of A=2 B=4 C=8 D=9 E=6 F=7

if we key in those text ( example an A ) in cell B1 then it will display the value
of 2 in a cell B2.

But if we key in any number ( example 3 or 5 or 1 ) in a cell B1 then it will display the value of 3 or 5 or 1 too .

Please help me with this one .. reall appreciate it ..

thanks

[kraljb]

What is the problem? It's hard to try and help when you don't say anything about what the problem really is...

[sricomm]

What is the problem? It's hard to try and help when you don't say anything about what the problem really is...

Really sorry sir .. just make some editing .. please help .. thanks .

[daddylonglegs]

Try this formula in B2

=IF(B1="","",IF(N(B1),B1,LOOKUP(B1,{"A","B","C","D","E","F","G";2,4,8,9,6,7,""})))

[sricomm]

Try this formula in B2

=IF(B1="","",IF(N(B1),B1,LOOKUP(B1,{"A","B","C","D","E","F","G";2,4,8,9,6,7,""})))

Many thanks sir .. it solve the problem .. thanks for the help .. really appreciate it ..