name & number gizmo

hi,
cells c1:c100 each contain a name, cells d1:d100 contain a specific number for each name.
i want be able to type a name into cell a:1 and get it's number in cell b:1 and also be able to type a number into cell b:1 and get it's name in cell a:1.
It would be useful if the name could be typed in in either lower or upper case and still work. cells c1:c100 and d1:d100 also need to be hidden. am using windows 8.

cw1, Good morning. You'll

cw1, Good morning.

You'll need to use VBA EXCEL programation to perform this like you desire.

Have a nice day.

thanks Mr Lobao, typing in

thanks Mr Lobao,
typing in the name is all that's really needed, typing in the number i can do without. to be able to do multiple names at once would be useful though eg cells a1:a10 to find b1:b10.
Also i can get by using upper case only if need be.
would it be possible to do this without VBA?

Yes you can do it without VBA

In cell B1 paste this formula
=VLOOKUP(A1,C1:D100,2,0)

Hope this helps

thanks for your help Jon

thanks for your help Jon