Home » Forums » Open Source Learning Center » Question and Answer

name & number gizmo

Submitted by cw1 on 22 November, 2014 - 10:08

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.

‹ Create a new sheet based on a cell value Querying a Table ›
»

cw1, Good morning. You'll

Submitted by Mr.Lobao on 22 November, 2014 - 15:16.

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

Submitted by cw1 on 22 November, 2014 - 17:36.

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

Submitted by Jon on 22 November, 2014 - 19:11.

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

Hope this helps

»

thanks for your help Jon

Submitted by cw1 on 27 November, 2014 - 12:02.

thanks for your help Jon

»