All solutions FormulaVLOOKUP Expert Solution – How to Use a VLOOKUP Formula

Excel - How to Use a VLOOKUP Formula - Expert Solution

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

I have an IF statement that works. Its pretty complicated with VLOOKUP. But i need to make this an OR statement and i keep getting errors and can't figure out the formula.
Solved by F. S. in 30 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 15/01/2017 - 03:24
Welcome
User 15/01/2017 - 03:24
Hello. I'm going to show you the working formula.. One sec.
Excelchat Expert 15/01/2017 - 03:24
Thanks for choosing ExcelChat!
User 15/01/2017 - 03:24
=ROUND(IF(IFERROR(VLOOKUP(B22255,PriceCharting!$A:$J,2,FALSE),"0")="Xbox One",VLOOKUP(B22255,PriceCharting!$A:$J,10,FALSE),IFERROR(VLOOKUP(B22255,PriceCharting!$A:$G,5,FALSE),"0"))*0.9,0)-0.01
User 15/01/2017 - 03:24
You are welcome, and hello.
Excelchat Expert 15/01/2017 - 03:25
Thanks
User 15/01/2017 - 03:25
If you look at the formula you will see that it checks to see if a condition matches the text "Xbox One".
User 15/01/2017 - 03:25
Using just this one IF statement the formula works.
User 15/01/2017 - 03:26
But i need to have this formula check on 4 other phrases in order to function. So if it matches either Xbox One or any of the other 4 phrases it will display one value, else the other.
User 15/01/2017 - 03:26
I'm running into a wall and can't figure it out. I keep getting errors.
User 15/01/2017 - 03:27
I hope you can help
Excelchat Expert 15/01/2017 - 03:28
Let me check, and grasp your requirement first
User 15/01/2017 - 03:28
Ok, thank you.
Excelchat Expert 15/01/2017 - 03:33
Can you share with me any sample data?
Excelchat Expert 15/01/2017 - 03:33
As last part of formula seems to be problematic
User 15/01/2017 - 03:34
I can maybe send you the entire sheet. Its big.. like 6mb
Excelchat Expert 15/01/2017 - 03:35
I just need some sample data to ensure the corrective action
User 15/01/2017 - 03:35
Will screenshots work?
Excelchat Expert 15/01/2017 - 03:36
Better you send me some data, as I have to check the formula out put
User 15/01/2017 - 03:38
ok, it might take a minute to get a working sheet, as in its current form its too big to upload
Excelchat Expert 15/01/2017 - 03:38
OK
Excelchat Expert 15/01/2017 - 03:40
Apparently, ELSE part of your formula and ROUND function syntax seems incorrect
User 15/01/2017 - 03:40
Thats weird because that formula is working ok.
Excelchat Expert 15/01/2017 - 03:43
Have you tried INDEX function?
User 15/01/2017 - 03:43
I am unable to upload the file. it must be too big.
User 15/01/2017 - 03:44
I'm going to try one other thing to shrink it.
Excelchat Expert 15/01/2017 - 03:44
You can send me dropbox or google docs link of your data
Excelchat Expert 15/01/2017 - 03:46
I will request my supervisor to send you back the file link
Excelchat Expert 15/01/2017 - 03:47
Better you send me google docs link, with problem statement and requirements description
User 15/01/2017 - 03:48
I have a mediafire account. I'll upload the sample file there.
User 15/01/2017 - 03:48
Are we about the get cut off? Looks like only 1 minute left.
Excelchat Expert 15/01/2017 - 03:48
Sessions time is short here, so please share the file link
Excelchat Expert 15/01/2017 - 03:49
You will get the solution of your query
User 15/01/2017 - 03:49
Working as fast as i can.. need to send an upload to the site
Excelchat Expert 15/01/2017 - 03:50
Even, if session time ends, you can re-post your problem here
Excelchat Expert 15/01/2017 - 03:50
with the file link
User 15/01/2017 - 03:51
http://www.mediafire.com/file/1p08wb6w7hh7e5m/Retail_Pricing_Test_Sample.xlsx
User 15/01/2017 - 03:51
that is the link file
User 15/01/2017 - 03:52
Are we still in session?
Excelchat Expert 15/01/2017 - 03:52
Thanks, I will send you back the file soon
Excelchat Expert 15/01/2017 - 03:52
Yes,
Excelchat Expert 15/01/2017 - 03:52
I have got it
User 15/01/2017 - 03:52
Thanks :)
Excelchat Expert 15/01/2017 - 03:52
Please rate our service at the end of this session
User 15/01/2017 - 03:52
Just FYI. the Formula i gave you goes on the VendAC tab
User 15/01/2017 - 03:53
in the retail_price column
User 15/01/2017 - 03:53
I will, thanks
Excelchat Expert 15/01/2017 - 03:53
Fine
Excelchat Expert 15/01/2017 - 03:53
Thanks for using ExcelChat!
Excelchat Expert 15/01/2017 - 03:53
Have a good day ahead
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