This formula works:
=VLOOKUP('Quote Notes'!B4,'[ml_customer list plus.xlsx]Customer List +'!A4:Z2001,21,FALSE)
Column 21 has some cells that are empty and in those instances I would like the return to read "Please provide"
I have tried:
=IFERROR(VLOOKUP ....) but realized this isn't an error, its just empty
~ and ~
=IF(VLOOKUP('Quote Notes'!B4,'[ml_customer list plus.xlsx]Customer List +'!A4:Z2001,21,FALSE)="'',"Please provide")
which does not work
~ and ~ a number of other combinations
I have ensured that the cells in column 21 are in fact empty and that the destination cell is formatted to receive text ('General')
Any ideas?
=VLOOKUP('Quote Notes'!B4,'[ml_customer list plus.xlsx]Customer List +'!A4:Z2001,21,FALSE)
Column 21 has some cells that are empty and in those instances I would like the return to read "Please provide"
I have tried:
=IFERROR(VLOOKUP ....) but realized this isn't an error, its just empty
~ and ~
=IF(VLOOKUP('Quote Notes'!B4,'[ml_customer list plus.xlsx]Customer List +'!A4:Z2001,21,FALSE)="'',"Please provide")
which does not work
~ and ~ a number of other combinations
I have ensured that the cells in column 21 are in fact empty and that the destination cell is formatted to receive text ('General')
Any ideas?