Question description:
This user has given permission to use the problem statement for this
blog.
If the data in A matches the data in C, then I need the data in E to be placed in B
Solved by X. W. in 40 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
20/04/2018 - 04:36
Hi. How may I help you today?
User
20/04/2018 - 04:37
If my Data in A matches my data in C, then I need the data from E to go into a new column B
User
20/04/2018 - 04:39
I have multiple cells that are the same in A and trying to get the data to match it to E
Excelchat Expert
20/04/2018 - 04:39
do you have a sample spreadsheet?
Excelchat Expert
20/04/2018 - 04:39
or can we just use dummy for illustration
User
20/04/2018 - 04:41
So A has repeated data, so for every 2 in A I need a B next to it in column B
Excelchat Expert
20/04/2018 - 04:41
ok... so if i understand you correct.. at anytime A and C are equal, you want B to get value of E?
User
20/04/2018 - 04:41
YES
Excelchat Expert
20/04/2018 - 04:41
what is the value of B when A and C are not equal?
User
20/04/2018 - 04:42
they need to be equal...
User
20/04/2018 - 04:42
to A represents a student
Excelchat Expert
20/04/2018 - 04:43
i row 6 what is the value you expect in B
User
20/04/2018 - 04:43
so very time student 2 is there, I need to have thier score (E) next to them
User
20/04/2018 - 04:43
the value of B is always equal to E
User
20/04/2018 - 04:44
so fate student 2, their score is always b (Column E)
User
20/04/2018 - 04:44
for*
Excelchat Expert
20/04/2018 - 04:44
so column A is like STUDENT column, same with C
Excelchat Expert
20/04/2018 - 04:45
and E is the grade of the student
User
20/04/2018 - 04:45
yes but they can be in A multiple times, where they are only in C once
User
20/04/2018 - 04:45
yes
Excelchat Expert
20/04/2018 - 04:45
got it .. let me create the formula :)
Excelchat Expert
20/04/2018 - 04:47
did i understand it correct?
User
20/04/2018 - 04:47
yes
Excelchat Expert
20/04/2018 - 04:47
great!
Excelchat Expert
20/04/2018 - 04:48
so the best excel function to use on this case is VLOOKUP
User
20/04/2018 - 04:48
I was trying that...
User
20/04/2018 - 04:49
what would the formula be?
User
20/04/2018 - 04:49
must have messed it up
Excelchat Expert
20/04/2018 - 04:49
=vlookup(A5,$C$4:$E$13,3,false)
Excelchat Expert
20/04/2018 - 04:50
=vlookup(lookup_value,table_array,col_index_num,range_lookup)
User
20/04/2018 - 04:51
I am still getting an error on my sheet
Excelchat Expert
20/04/2018 - 04:51
is it possible to share the actual excel here?
Excelchat Expert
20/04/2018 - 04:52
or maybe share a picture?
User
20/04/2018 - 04:53
no....its student data...
User
20/04/2018 - 04:53
:(
Excelchat Expert
20/04/2018 - 04:53
ok... lets do it this way
Excelchat Expert
20/04/2018 - 04:53
your data starts at which row?
User
20/04/2018 - 04:55
its exactly the example I gave with rows and columns
Excelchat Expert
20/04/2018 - 04:56
the value in B4 is it correct?
User
20/04/2018 - 04:57
it reads ref now....
User
20/04/2018 - 04:58
let em play with it...I am a visual learner so I think there is a video out there
Excelchat Expert
20/04/2018 - 04:59
in your own excel..can you put this in B4?
Excelchat Expert
20/04/2018 - 04:59
=VLOOKUP(A4,C:E,3,FALSE)
User
20/04/2018 - 05:01
YES!!! this worked!!!
Excelchat Expert
20/04/2018 - 05:01
the difference lies on the array
Excelchat Expert
20/04/2018 - 05:01
i would always ask if the value on B4 is correct... then we are on the right track
User
20/04/2018 - 05:02
so expliain what the fdormula means
User
20/04/2018 - 05:02
because i need to do it again
Excelchat Expert
20/04/2018 - 05:02
if it doesnt work for some of the rows then we have a problem with the array
Excelchat Expert
20/04/2018 - 05:02
on the formula i made the array use column C to E
Excelchat Expert
20/04/2018 - 05:02
no specific cells
Excelchat Expert
20/04/2018 - 05:03
student 2 and his grade can be on row 1000 and it will still work :)
Excelchat Expert
20/04/2018 - 05:04
because the array defined points to all cells from columns C to E
Excelchat Expert
20/04/2018 - 05:04
can you still follow?
Excelchat Expert
20/04/2018 - 05:05
option 1 : =vlookup(A5,$C$4:$E$13,3,false)
Excelchat Expert
20/04/2018 - 05:05
option 2 : =VLOOKUP(A4,C:E,3,FALSE)
Excelchat Expert
20/04/2018 - 05:07
option 1 works on the sample but if grade we are looking for is within rows 4 thru 13... as I am not sure how big your data is, i thought its best to use the whole column as reference
Excelchat Expert
20/04/2018 - 05:07
applied on option 2
User
20/04/2018 - 05:08
perfect. I have 2200 students in A, so I knew there had to be something faster than me typing it all in one by one
Excelchat Expert
20/04/2018 - 05:09
great!
User
20/04/2018 - 05:09
HOw much is this service monthly?
Excelchat Expert
20/04/2018 - 05:10
to be honest, this is my first time to do this and i am not sure on the charging
Excelchat Expert
20/04/2018 - 05:10
that is why im a little bit struggling with the shortcuts i am used to, sorry for that
User
20/04/2018 - 05:10
oh well you were great!
Excelchat Expert
20/04/2018 - 05:10
thanks
Excelchat Expert
20/04/2018 - 05:11
glad to help..
Excelchat Expert
20/04/2018 - 05:11
anything other related questions i can help you with?
User
20/04/2018 - 05:12
no thats was all! Thanks again!
Excelchat Expert
20/04/2018 - 05:12
thank you for using got it.
Excelchat Expert
20/04/2018 - 05:13
have a nice day!
Excelchat Expert
20/04/2018 - 05:13
and please feel free to come back anytime, happy to serve
Excelchat Expert
20/04/2018 - 05:15
Please give your kind feedback for our service
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.