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.