Question description:
This user has given permission to use the problem statement for this
blog.
i want to write a formula like "if value of B2 exist in A:A show C2 value else show "NA"
Solved by V. A. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
10/09/2017 - 07:22
Hello, I understand that you need help with an IF and match function, right? Are you able to give me a sample data we can work on?
User
10/09/2017 - 07:22
ya giving
Excelchat Expert
10/09/2017 - 07:23
Preferably, you sample data mirrors your actual data so there'll be no need to edit the formula.
User
10/09/2017 - 07:23
ya
User
10/09/2017 - 07:24
so as given i need in D values od b
User
10/09/2017 - 07:24
values of B
User
10/09/2017 - 07:24
matchin A and C
Excelchat Expert
10/09/2017 - 07:24
So if C exists in A then give B value?
User
10/09/2017 - 07:25
ya
User
10/09/2017 - 07:25
ya
Excelchat Expert
10/09/2017 - 07:25
Please see the formula in column D.
Excelchat Expert
10/09/2017 - 07:25
Basically, what we used is the combination of Index Match. However, we can also use the standard vlookup() formula for this.
User
10/09/2017 - 07:26
can u use it and show me???
Excelchat Expert
10/09/2017 - 07:26
Column E has the Vlookup formula.
User
10/09/2017 - 07:27
ok thanks for help
Excelchat Expert
10/09/2017 - 07:27
Vlookup is the simpler approach, basically you are just telling it to look for the C3 value in column A then return the adjacent cell in B.
Excelchat Expert
10/09/2017 - 07:27
Entering Explanation Phase
Excelchat Expert
10/09/2017 - 07:27
Vlookup is the simpler approach, basically you are just telling it to look for the C3 value in column A then return the adjacent cell in B.
Excelchat Expert
10/09/2017 - 07:27
Entering Discussion Phase
Excelchat Expert
10/09/2017 - 07:27
Do you have any questions regarding the solution provided?
User
10/09/2017 - 07:28
whats 2 saying in vlook formula
Excelchat Expert
10/09/2017 - 07:28
It means to return the 2nd adjacent column.
Excelchat Expert
10/09/2017 - 07:28
If you change that to 1, it'll return column A.
User
10/09/2017 - 07:28
and 0?
Excelchat Expert
10/09/2017 - 07:29
0 means EXACT match.
User
10/09/2017 - 07:29
ok thanks
Excelchat Expert
10/09/2017 - 07:29
You can actually change 0 to FALSE and it will still work.
User
10/09/2017 - 07:29
ok
Excelchat Expert
10/09/2017 - 07:29
By the way, do you have time for a quick survey?
User
10/09/2017 - 07:29
ya sure
Excelchat Expert
10/09/2017 - 07:29
Have you heard of the new subscription version of Excel? You can keep using your existing computer/laptop and get latest features automatically like online file sharing, and even a browser version of Excel that work with your files. I like it.
User
10/09/2017 - 07:29
yA
Excelchat Expert
10/09/2017 - 07:30
You should try it. It doesn’t cost much. It’s called Office 365 Business.
User
10/09/2017 - 07:30
ok
Excelchat Expert
10/09/2017 - 07:30
If you’re interested, let me know and I’ll tell me manager to add helping you upgrade as a service to our website.
Excelchat Expert
10/09/2017 - 07:30
Thanks for your response and time. :)
Excelchat Expert
10/09/2017 - 07:30
I'd appreciate a 5-star rating if you think I deserve it. :)
Excelchat Expert
10/09/2017 - 07:30
Please do not forget to click the End Session button so we may help other clients in need. Thank you.
Excelchat Expert
10/09/2017 - 07:31
https://docs.google.com/spreadsheets/d/1I45nnslqVbOtSXP8KMgA-lBhRYYb8MlS-4TDz28Q9jI/edit?usp=sheets_home&ths=true
Excelchat Expert
10/09/2017 - 07:31
You can download the sheet by going to the link above, clicking FILE > DOWNLOAD AS > Microsoft Excel (.xlsx)
Excelchat Expert
10/09/2017 - 07:32
Please do not forget to click the End Session button so we may help other clients in need. Thank you.
Excelchat Expert
10/09/2017 - 07:33
Please do not forget to click the End Session otherwise I'll be stuck here until the timer expires and be unable to help others. Thank you.
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.