**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