Hi all,
I am having an issue changing a formula that works to do something else if the reference cell is actually blank ( i have searched and not found a similar scenario ?)
My working formula is this:
It will look at J16 (in this instance) and vlookup in the different sheet and return either the corresponding entry or 'noadaccount' as it should.
The trouble i'm having is this is a bit of a mess where j16 has a blank entry, i need it to return nothing i.e ""
so i changed the formula to this:
unfortunately this returns a #value error stating
"Error in Value
A value used in the formula is of the wrong data type."
could this be an issue with the sheet formatting or an issue with the formula ? i'm really stumped on this.
I am having an issue changing a formula that works to do something else if the reference cell is actually blank ( i have searched and not found a similar scenario ?)
My working formula is this:
Excel Formula:
=IFERROR(VLOOKUP(J16,ad_users_03112022!$A$1:$B$1213,2,FALSE),"NOADACCOUNT")
The trouble i'm having is this is a bit of a mess where j16 has a blank entry, i need it to return nothing i.e ""
so i changed the formula to this:
Excel Formula:
=IF(J16="", "", IF(VLOOKUP(J16,ad_users_03112022!$A$1:$B$1213,2,FALSE),"NOADACCOUNT")
"Error in Value
A value used in the formula is of the wrong data type."
could this be an issue with the sheet formatting or an issue with the formula ? i'm really stumped on this.