Excel Formula

[shonu1320]

Can somebody explain this formula to me?
=IF(ISERROR(IF(ISBLANK($B$3),"",IFERROR(IFERROR(VLOOKUP(B3,SPR!A:I,2,0),VLOOKUP(B3,PLY!A:I,2,0)),VLOOKUP(B3,DC!A:I,2,0)))),"NOT FOUND",IF(ISBLANK($B$3),"",IFERROR(IFERROR(VLOOKUP(B3,SPR!A:I,2,0),VLOOKUP(B3,PLY!A:I,2,0)),VLOOKUP(B3,DC!A:I,2,0))))

This formula brings the description of the item number we enter in the box to the left of it. I m trying to figure out how this formula is working? Like what all the conditions are there in the formula?

=IF(ISBLANK($B$3),"",IF(ISERROR(VLOOKUP($B$3,PLY!A:I,5,0)),"",VLOOKUP($B$3,PLY!A:I,5,0)))

For the same item(above) this particular formula is pulling the name of the supplier. Again I am trying to figure out how the formula is constructed?

Can anybody help me please!

 

[Aladin Akyurek]

Is the item number a real number?

Regarding the 2nd formula: Since you seem to have the IFERROR function...

=IF($B$3="","",IFERROR(VLOOKUP($B$3,PLY!A:I,5,0),""))

 

[shonu1320]

Yes, it is a real number. Somebody who was working previous to me on this job wrote this formula and I am having hard time trying to figure out what they did. It is bringing the correct result, I just wish I could simplify it with some help.

 

[scottylad2]

IF(ISBLANK($B$3),"" says if B3 is blank, leave the cell the formulas in Blank

IF(ISERROR(VLOOKUP($B$3,PLY!A:I,5,0)),"", this is the first part of an IF function, which is saying if the Vlookup returns an error, leave the cell the formulas in blank,

the second Vlookup is what will happen if there's no error
VLOOKUP($B$3,PLY!A:I,5,0)))

so strung together, it says if B3 is Blank leave Blank, if the Vlookup returns an error leave Blank, if there's no error run the Vlookup

I'd lose the iSblank part altogether because if B3 return black you will get an error in the Vlookup, which is already taken care of in the Iserror part of the formula

 

[shonu1320]

Thank you for explaining it so well and it worked perfectly without that ISBlank statement.

Could you please explain the first formula also and suggest if there is a way to make it simpler.

Really appreciate your help! I am new at this job and really having hard time!

 

[Aladin Akyurek]

Yes, it is a real number. Somebody who was working previous to me on this job wrote this formula and I am having hard time trying to figure out what they did. It is bringing the correct result, I just wish I could simplify it with some help.

=IF(B3="","",LOOKUP(9.999999999999999E+307,CHOOSE({1,2,3,4},0,
    VLOOKUP(B3,DC!A:I,2,0),VLOOKUP(B3,PLY!A:I,2,0),VLOOKUP(B3,SPR!A:I,2,0)

When B3 is empty/blank, return blank.
Otherwise, run the three VLOOKUP's, collect their results in a vector/array, and return the last numeric value from that vector.

Custom format the formula cell as:

[=0]"";General