Hi all, I'm looking at improving this formulaWhere in A28 is a number or text string. But sometimes in this cell is "0" so I want to ignore that![]()
Please Login or Register to view this content.
I origianlly hadbut when A28 is a 4 digit number it displays blank.![]()
Please Login or Register to view this content.
So i was thinking of something along the lines of =IF(LEN($A28)<3,IFERROR(VLOOKUP($A28,InstallTemp!$C:$J,6,FALSE),0),"") but i cant get that to work.
Any Ideas,
Thanks in advance.
John
Bookmarks