Hi,
I am wondering if it is possible to have index items hardcoded on the formula.
I need something like this, if possible
to return A,B,C or DFormula:Please Login or Register to view this content.
Hi,
I am wondering if it is possible to have index items hardcoded on the formula.
I need something like this, if possible
to return A,B,C or DFormula:Please Login or Register to view this content.
If you think someone helped you, click on the "* Add Reputation" as a way to say thank you.
If your problem is solved, go to Thread Tools and select Mark This Thread Solved
With values of 1 to 4 in A1, you could put this formula in B1:
=INDEX({"A","B","C","D"},A1)
which will return the appropriate text value.
Hope this helps.
Pete
I usually start with something like this
=CHAR(ROW($1:$5)+64)
in the formula bar and hit the F9 function key to get this
={"A";"B";"C";"D";"E"}
or =TRANSPOSE(CHAR(ROW($1:$5)+64))
to get this
={"A","B","C","D","E"}
Then do as Pete has done.
Dave
Thanks Pete.
I tried to use random number in A1
Formula:Please Login or Register to view this content.
By the way, is it possible to make it dynamic by replacing the number 4 which is the number of the elements with count function ,Formula:Please Login or Register to view this content.
Something like
Formula:Please Login or Register to view this content.
by entering ONLY once the array elements
Last edited by saravnepali; 12-15-2019 at 09:33 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks