**Question description:**

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

I WANT TO WRITE A FORMULA THAT SAYS IF THE NUMBER IN COLUMN A MATCHES THE NUMBER IN COLUMN B THE INSERT THE NUMBER FROM COLUMN C INTO COLUMN D

Solved by A. W. in 20 mins

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

Excelchat Expert
07/10/2018 - 04:58

Hi

User
07/10/2018 - 04:58

HI

Excelchat Expert
07/10/2018 - 04:58

Welcome to Excelchat

Excelchat Expert
07/10/2018 - 04:58

I can help you with that problem
Before we get started, this is a reminder that our policy is 1 problem per session with additional Q&A on that problem as time allows

Excelchat Expert
07/10/2018 - 04:59

Let me ask you a couple of quick questions to make sure I fully understand your problem

Excelchat Expert
07/10/2018 - 05:00

what if the number in column A does not match number in column B you want me to return some default value

Excelchat Expert
07/10/2018 - 05:00

hi are you there

User
07/10/2018 - 05:00

THANK YOU I AM LOOKING TO COMBINE INFORMATION FROM TWO TABLES TO CREATE A THIRD. i HAVE A COLUMN IN ONE TABLE THAT HAVE DUPLICATE INFORMATION IN ANOTHER TABLE PLUS ANOTHER COLUMN I NEED

Excelchat Expert
07/10/2018 - 05:01

can you share the data

Excelchat Expert
07/10/2018 - 05:01

can you please elaborate bit on what you need

User
07/10/2018 - 05:04

So I am merging two systems and each system has a stock number but only one system has the location of th stock number so I would like to be able to say if your stock number is 10 then you go on shelf 5 but since there are 1700 stock number and only 100 shelves I need to be able to say if your stock number is 10 on table one and yur stok number is 10 on table two than go to column c and it will tell you what shelf you shelf go on'

Excelchat Expert
07/10/2018 - 05:04

Hi if value in column A matches with value in column C i am getting the value in D to to column F

User
07/10/2018 - 05:04

yes

Excelchat Expert
07/10/2018 - 05:05

so does this solve your problem

User
07/10/2018 - 05:05

yes

Excelchat Expert
07/10/2018 - 05:05

i can explain what i have done if you have time

User
07/10/2018 - 05:05

yes

Excelchat Expert
07/10/2018 - 05:06

basically i have used vlookup

User
07/10/2018 - 05:06

ok can you help me with the formula

Excelchat Expert
07/10/2018 - 05:07

=VLOOKUP(Value you want to look up, range where you want to lookup the value, the column number in the range containing the return value, Exact Match or Approximate Match – indicated as 0/FALSE or 1/TRUE).

Excelchat Expert
07/10/2018 - 05:07

yes i can

Excelchat Expert
07/10/2018 - 05:07

basically it is looking up a value in the specified array range C1:D3 in our example

User
07/10/2018 - 05:08

i don't unserstand how to write the formula and in what cell

Excelchat Expert
07/10/2018 - 05:08

we have specified 2 because we need the value from 2nd column in our array "C1:D3"

Excelchat Expert
07/10/2018 - 05:09

oh.. you can upload your spreadsheet i can help you with your exact problem

Excelchat Expert
07/10/2018 - 05:09

see first value is the value that you ant to lookup

Excelchat Expert
07/10/2018 - 05:09

and 2nd is the range in which you want to lookup

Excelchat Expert
07/10/2018 - 05:10

next is the column value to retrieve

User
07/10/2018 - 05:10

I see you example but i don't know the formula to get the answer so you showing me it works is great but I dont know how to make it work in my spreadsheet

Excelchat Expert
07/10/2018 - 05:10

0 in the end because wee need exact match

Excelchat Expert
07/10/2018 - 05:11

yeah you upload your sheet

Excelchat Expert
07/10/2018 - 05:11

so that i can work on it and solve it

Excelchat Expert
07/10/2018 - 05:13

hi are you there?

Excelchat Expert
07/10/2018 - 05:14

hi are you there?

Excelchat Expert
07/10/2018 - 05:14

please respond if you are there

Excelchat Expert
07/10/2018 - 05:16

Do you have any other questions about this problem and the solution

Excelchat Expert
07/10/2018 - 05:17

Thanks for coming to Excelchat. Feel free to leave any comments or feedback. Have a nice day

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