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
