Forgotten what command

AlexanderBB

Well-known Member
Joined
Jul 1, 2009
Messages
1,705
Age is a terrible thing!! Can't remember the command for
= ("abc",1,"def",2,"ghi", 3)
the number returns the corresponding string (or maybe vice versa).
Can anyone help? Thanks.
 

Some videos you may like

Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.

Perpa

Well-known Member
Joined
Dec 18, 2012
Messages
632
AlexanderBB,
Give this a try...

=RIGHT(LEFT("abcdefghijklmnopqrstuvwxyz",A1*3),3)

Put 1 to 9 in A1

Perpa
 

AlexanderBB

Well-known Member
Joined
Jul 1, 2009
Messages
1,705
Thanks Perpa, that's clever. I remembered what I wanted - Choose - except that wasn't quite it
as I need a number for a known string. Solved with a collection object.
 

Watch MrExcel Video

Forum statistics

Threads
1,109,084
Messages
5,526,755
Members
409,717
Latest member
Oscarsalone

This Week's Hot Topics

Top