Hi to return "trimmed" telephone numbers from a database I have devised this
works fine and displays nothing if lookup cell for name is empty![]()
=IFERROR("0"&RIGHT(VLOOKUP($H3,DriverGrid_20052016_110032.xls!$C$1:$F$54,2),10),"")
How can I add ISBLANK so that if cell in C1:f54 is blank then display nothing rather than the zero displayed now
Any help appreciated
Bookmarks