Forum Discussion
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)))
Do you get an error with the formula? If so, what does it say?
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
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 🙂
