All solutions IFVLOOKUP Expert Solution – How to Use VLOOKUP and IF Function Together

Excel - How to Use VLOOKUP and IF Function Together - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

Hi, my VLOOKUP isn't working. No matter what I do it is returning the same result regardless of the sku it is searching for - even if I copy and paste the sky into the sheet the exact same way it is typed in the sheet its searching
Solved by X. H. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 30/03/2018 - 12:38
Hi
Excelchat Expert 30/03/2018 - 12:38
Welcome to got it pro
Excelchat Expert 30/03/2018 - 12:39
do you have some sample data so that i can see where you are stuck
Excelchat Expert 30/03/2018 - 12:41
are you there?
Excelchat Expert 30/03/2018 - 12:44
Hey
Excelchat Expert 30/03/2018 - 12:44
you there?
User 30/03/2018 - 12:45
so sorry! I was so engrossed in my work I forgot about this, I worked it out now, I stupidly hadn't converted to numbers on the cell I was looking up
Excelchat Expert 30/03/2018 - 12:45
ohk
User 30/03/2018 - 12:45
so so so sorry!
User 30/03/2018 - 12:45
but thanks anyway :)
Excelchat Expert 30/03/2018 - 12:45
meanwhile i have also demonstrated on spread sheet
Excelchat Expert 30/03/2018 - 12:45
no problem
Excelchat Expert 30/03/2018 - 12:46
Please do give good rating
Excelchat Expert 30/03/2018 - 12:46
it would really help
Excelchat Expert 30/03/2018 - 12:46
i would have loved to helped you
Excelchat Expert 30/03/2018 - 12:46
but you figured out
Excelchat Expert 30/03/2018 - 12:46
:)
Excelchat Expert 30/03/2018 - 12:46
please do give good rating once you end the session
Excelchat Expert 30/03/2018 - 12:47
when you are using vlookup make sure things are in same format..so that helps a lot
User 30/03/2018 - 12:47
yes I will for sure, and yes that was the issue, I think i've gone cross eyed from looking at it haha!
Excelchat Expert 30/03/2018 - 12:48
haha
Excelchat Expert 30/03/2018 - 12:48
take care buddy
Excelchat Expert 30/03/2018 - 12:49
you can end the session :)

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.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc