Hello All,
Can I have a code of Vlookup
=IF(B1=0,"",IF(D1=55,"ERROR",H1)) while the real 55 is 55-xxxxxxxxx-xx.
Regards,
tt3
Hello All,
Can I have a code of Vlookup
=IF(B1=0,"",IF(D1=55,"ERROR",H1)) while the real 55 is 55-xxxxxxxxx-xx.
Regards,
tt3
Last edited by tuongtu3; 12-14-2012 at 02:24 PM. Reason: Solved
Hi,
Using LEFT(D1,2)*1 instead of D1 might help...
=IF(B1=0,"",IF(LEFT(D1,2)*1=55,"ERROR",H1))
Last edited by [email protected]; 12-14-2012 at 03:44 AM.
Hi Nested,
Thank you very much for your time and help. It works.
Regards,
tt3
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks