Need help understanding complicated IF formula in order to update

Hello!

OK, so I have a dilemma :/ I was given instructions by my boss to update the below IF statement in the attached google drive link with Excel sheet at the bottom of thread, which has a few tabs but I have saved the file in the tab where the formula I'm referring to is and I've highlighted in yellow and circled the header under it so you can easily find it.

This is the formula:
=IF(BW1="INACTIVE_UPC",VLOOKUP(CG1,Info!$B$1:$F$25,5,FALSE),IFERROR(VLOOKUP($B1,'Details-Products'!$P$7:$BR$170169,51,FALSE),"-"))

It's pretty advanced.. hopefully someone can take a look and understand what it's doing pretty easily, for me, it's like ready a foreign language in a different alphabet. I don't know:
- what the formula is looking at
- what it's doing
- what I need to do with it in order to do the following that my boss requested: she said: "we need this IF statement to factor in "Workflow Type". This is column BR in the tab where that formula is, but it's also in the other tab called: "Details Products" in column BJ. I don't understand what the formula is doing, the logic of it given the whole template, and I don't know what "factoring in Workflow Type" would imply in this formula given all the info in the template and all the other formulas and logic in the sheet. I guess there are other formulas in the sheet that also do that with IF statements, mainly in the "Details Product" tab... looks like there is a formula in column CJ in that tab that adjusts things based on Workflow Type. I don't know. I'm so confused.

I know this is probably impossible for anyone to help me figure out just by studying the template and get a quick grasp on logic, but thought I would try and see if there might be a genius with a little free time in here who might get it easily and help. Some people look at templates like that with a million formulas and macros etc. and get the whole logic in 2 seconds.. like my boss hah. This is a quizz. Help!

I SO APPRECIATE IT!!!

And feel free to ask me as many questions as you need that might help. Hopefully I can help you help me.

https://drive.google.com/file/d/0B-D...ew?usp=sharing

Will you please attach the workbook here? Many members will not or cannot access file-sharing sites.

Unfortunately the attachment icon doesn't work at the moment, so to attach an Excel file you have to do the following: just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

Taking the formula bit by bit:

=IF(BW1="INACTIVE_UPC",

If BW1 contains the text "INACTIVE_UPC", then do this:

VLOOKUP(CG1,Info!$B$1:$F$25,5,FALSE),

If it doesn't, do this instead:

IFERROR(VLOOKUP($B1,'Details-Products'!$P$7:$BR$170169,51,FALSE),"-"))

This bit:

VLOOKUP(CG1,Info!$B$1:$F$25,5,FALSE)

is telling Excel to find the value in CG1 in the first column of the range Info!$B$1:$F$25 and return what it finds on the same row in the fifth column of that array (F).

This bit:

IFERROR(VLOOKUP($B1,'Details-Products'!$P$7:$BR$170169,51,FALSE),"-"))

is telling Excel to find the value in B1 in the first column of the range 'Details-Products'!$P$7:$BR$170169 and return what it finds on the same row of the 51st column of that array. If this returns an error, Excel is to return "-".

file size: ca. 140 MB
Your file has ca. 56k (56 000) unnecessary styles
You should clean workbook from spaces, not used formulas etc etc.
After that you will get file size ca. 3 MB (xlsb) , 10 MB (xlsm)
What do you think about it?

Because Sucuri don't like me , here is: XLSB file