# Excel - IF Function Problem - Expert Solution

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
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.

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.

## Click here to get your free Excelchat help session

Trusted by people who work at