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(VLOOKUP([@NAME],tblPersonnelInfo,5,0)," "))
and here is my table:
TIA
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)))
