**Question description:**

*This user has given permission to use the problem statement for this
blog.*

i need a formula to put the value in column f into column c, when/if column c matches column b.

Solved by F. J. in 20 mins

This is the chat thread from the real Excelchat help session. It contains no private user
information.

Excelchat Expert
11/04/2018 - 01:04

hi

User
11/04/2018 - 01:04

hi

Excelchat Expert
11/04/2018 - 01:04

ok go on

User
11/04/2018 - 01:05

sorry im trying to put my data into this sheet.

Excelchat Expert
11/04/2018 - 01:05

yes, go ahead

User
11/04/2018 - 01:06

basically, i have data organized by subject - and then a variety of other measures. so its like this:

User
11/04/2018 - 01:08

i want to make a formula that will put the value (in d) associated with the subject id number (a and c) for each row of b.

Excelchat Expert
11/04/2018 - 01:08

oh, i think we can use vlookup there

Excelchat Expert
11/04/2018 - 01:08

for a moment

Excelchat Expert
11/04/2018 - 01:08

are you familiar with vlookup?

User
11/04/2018 - 01:09

no

User
11/04/2018 - 01:09

its vba stuff?

Excelchat Expert
11/04/2018 - 01:09

nope

Excelchat Expert
11/04/2018 - 01:09

just a useful excel formula

Excelchat Expert
11/04/2018 - 01:10

take a look at the formula in column B

User
11/04/2018 - 01:10

yeah. what is the 2 and 0?

Excelchat Expert
11/04/2018 - 01:10

2 means second column in reference column C to D

Excelchat Expert
11/04/2018 - 01:11

0 means i need to have the exact match

User
11/04/2018 - 01:11

oooo!

User
11/04/2018 - 01:11

wow! easy! thanks!

Excelchat Expert
11/04/2018 - 01:11

great :)

Excelchat Expert
11/04/2018 - 01:11

you may click done now if we already solved your problem

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