LinkBack URL
About LinkBacksInstead of code, how about a formula to do exactly the same thing. It
works by nesting your VLOOKUP into an IF:
=IF(AND(B1<>"",ISNUMBER(SEARCH("total",D1,1))), your vlookup formula
here,"")
Instead of code, how about a formula to do exactly the same thing. It
works by nesting your VLOOKUP into an IF:
=IF(AND(B1<>"",ISNUMBER(SEARCH("total",D1,1))), your vlookup formula
here,"")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks