Hello, hello. This is more a question of why does this work. I LOVE the fact it does but I've chatted with several Excel folks and no one in my personal circle can tell me why this works. I'm doing some VBA work for a colleague and I noticed she has a formula that reads:
=IFERROR(""""&VLOOKUP($B16,tbl_Status,2,0),"""")
I get the the whole piece about it returning the value from column 2 of tbl_Status if it finds B16 in tbl_Status. However, what it actually does if it doesn't find a match to B16 is what is fascinating to me. If it doesn't find it based on the end of the IFERROR I would expect a blank, but without the first part, """"&, it doesn't return a blank, it returns a 0. I don't know if this is relevant but the B16 this is referring to is a value in a pivot table.
Why does adding the """"& to this return a blank instead of a 0?
Curious minds want to know.
=IFERROR(""""&VLOOKUP($B16,tbl_Status,2,0),"""")
I get the the whole piece about it returning the value from column 2 of tbl_Status if it finds B16 in tbl_Status. However, what it actually does if it doesn't find a match to B16 is what is fascinating to me. If it doesn't find it based on the end of the IFERROR I would expect a blank, but without the first part, """"&, it doesn't return a blank, it returns a 0. I don't know if this is relevant but the B16 this is referring to is a value in a pivot table.
Why does adding the """"& to this return a blank instead of a 0?
Curious minds want to know.