# 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 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
Excelchat Expert 10/09/2017 - 07:31
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.

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.