Forum Discussion
Solved
If and V lookup help
Hi, I am trying to get the formula to return a space if nothing is contained within my 2nd table (tblPersonnelInfo). What am I doing wrong? Here is my data & formula=IF([@NAME]="","",IFERROR(VLOOKU...
Try this:
=IF([@NAME]="","",LET(v,IFERROR(VLOOKUP([@NAME],tblPersonnelInfo,5,FALSE),""),IF(v="","",v)))
I don't get an error but I don't want the 0 to appear if no email has been entered in my table. I've attached a sample workbook.
thanks for looking at it.
Try this:
=IF([@NAME]="","",LET(v,IFERROR(VLOOKUP([@NAME],tblPersonnelInfo,5,FALSE),""),IF(v="","",v)))
- Thank you so much, that worked. I don't really know what this formula is but it worked 🙂