Excel - IF Function Problem - Expert Solution

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.

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.