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