# Excel - COLUMN Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

I have 10 groups of 10 names in a column, and need a formula for Excel to output a name when someone randomly chooses first a group, and then one of the names in that group, but does both things at the same time
Solved by Z. C. in 33 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 05/06/2018 - 06:22
Excelchat Expert 05/06/2018 - 06:23
hello
User 05/06/2018 - 06:23
Hi. I have 100 names, in 10 groups of 10 down column A
User 05/06/2018 - 06:24
like this, for example using two sets
Excelchat Expert 05/06/2018 - 06:24
ok,
User 05/06/2018 - 06:25
i need a formula that pulls a letter from my list based on which group is chosen (option 1) and which letter of that chosen group is chosen (option 2). Right now, it should be "o"
Excelchat Expert 05/06/2018 - 06:25
then what is the option 1 and option 2?
User 05/06/2018 - 06:26
does that make sense?
User 05/06/2018 - 06:27
I'm thinking it's a VLOOKUP problem, but don't know how to account for the variables to narrow it down
Excelchat Expert 05/06/2018 - 06:27
if i select in option1 as 2, the answer was letter B right?
Excelchat Expert 05/06/2018 - 06:27
then if the value on option 2 was 5, the value was o?
Excelchat Expert 05/06/2018 - 06:28
is in it correct?
User 05/06/2018 - 06:28
one sec
User 05/06/2018 - 06:28
option 1 chooses which group
Excelchat Expert 05/06/2018 - 06:28
ok :)
User 05/06/2018 - 06:28
option two chooses which name in the previously chosen group
Excelchat Expert 05/06/2018 - 06:28
oh ok I get it
User 05/06/2018 - 06:28
so 2, 5 should give "o", while 1, 5 should give "e"
User 05/06/2018 - 06:29
cool, sorry
Excelchat Expert 05/06/2018 - 06:29
just five me a minute to work on this
User 05/06/2018 - 06:29
yea, of course
Excelchat Expert 05/06/2018 - 06:31
here it is :)
User 05/06/2018 - 06:32
so it's not a VLOOKUP at all?
Excelchat Expert 05/06/2018 - 06:32
we can use also vlookup, however in vlookup we need to add another column,
Excelchat Expert 05/06/2018 - 06:32
for as we can lookup the value that we want
User 05/06/2018 - 06:33
ok, one small question then
Excelchat Expert 05/06/2018 - 06:33
but in Index function, it was just easily lookup the value in row & column
Excelchat Expert 05/06/2018 - 06:33
ok
Excelchat Expert 05/06/2018 - 06:33
what is it?
User 05/06/2018 - 06:33
my actual sheet will have 100 names, 10 sets of 10.
Excelchat Expert 05/06/2018 - 06:34
ok, could i have that data?
Excelchat Expert 05/06/2018 - 06:34
so we can check for the formula for that one
User 05/06/2018 - 06:35
one sec :)
Excelchat Expert 05/06/2018 - 06:35
ok :)
User 05/06/2018 - 06:36
so the formula still works, which means you are amazing, i just need to know how to make the selection range bigger
Excelchat Expert 05/06/2018 - 06:36
oh it has a number of group
User 05/06/2018 - 06:36
yep, 10 of them
Excelchat Expert 05/06/2018 - 06:37
Excelchat Expert 05/06/2018 - 06:37
give me a second and I will show it to you :)
User 05/06/2018 - 06:37
you're amazing
Excelchat Expert 05/06/2018 - 06:37
thanks :)
User 05/06/2018 - 06:43
you still with me?
Excelchat Expert 05/06/2018 - 06:44
yes
Excelchat Expert 05/06/2018 - 06:44
im near on the solution now
User 05/06/2018 - 06:44
oh wow, ok. I knew this was going to be complicated, sorry!
Excelchat Expert 05/06/2018 - 06:45
done :)
Excelchat Expert 05/06/2018 - 06:45
have you seen it now?
Excelchat Expert 05/06/2018 - 06:46
r u still there?
User 05/06/2018 - 06:46
yep
Excelchat Expert 05/06/2018 - 06:47
ok, could you check it now :)
Excelchat Expert 05/06/2018 - 06:47
it this was the output that you want
User 05/06/2018 - 06:47
i am, and I'm getting a reference error
Excelchat Expert 05/06/2018 - 06:47
on which?
User 05/06/2018 - 06:48
wait, nevermind. I just copied what was in the sample screen instead of trying to copy and paste separately
Excelchat Expert 05/06/2018 - 06:48
ok :)
User 05/06/2018 - 06:48
one sec, just testing
Excelchat Expert 05/06/2018 - 06:48
ok :)
User 05/06/2018 - 06:51
it's working great :)
Excelchat Expert 05/06/2018 - 06:51
oh great :)
Excelchat Expert 05/06/2018 - 06:51
Excelchat Expert 05/06/2018 - 06:52
what I did here, I've set a index function for each group
Excelchat Expert 05/06/2018 - 06:52
like this one
User 05/06/2018 - 06:52
i see that. that seems like a simple solution
Excelchat Expert 05/06/2018 - 06:52
IF(E3=1,INDEX(A1:A10,F3,1)
User 05/06/2018 - 06:52
and then nested the ifs into one formula
Excelchat Expert 05/06/2018 - 06:53
yes correctly :)
Excelchat Expert 05/06/2018 - 06:53
User 05/06/2018 - 06:53
perfect. so what do i do now? as in, do i give you feedback or something?
Excelchat Expert 05/06/2018 - 06:54
yes, once we ended our session, you may send me rating and your feedbeack :)
User 05/06/2018 - 06:54
great, will do
Excelchat Expert 05/06/2018 - 06:54
5 star if i satisfied your question
Excelchat Expert 05/06/2018 - 06:55
:)
User 05/06/2018 - 06:55
10 star
Excelchat Expert 05/06/2018 - 06:55
wow thanks so much :)
Excelchat Expert 05/06/2018 - 06:55
Thanks for using Got It Pro. Please give your kind feedback for our service. On your window, kindly don't just close the window, there is an end button there so you could end the session properly & message will appear to ask for the feedback :) Have a good day ahead ^_^

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

#### Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.