hello, i am trying to combine the following 2 formulas into one complete formula. is it possible? any help would be greatly appreciated. thank you.
=VLOOKUP(B1,DATA!A:C,2,FALSE)
=(IF(C1<>"",SUBSTITUTE(SUBSTITUTE(E1,"!",A1&"|"),"@","::"&C1),SUBSTITUTE(SUBSTITUTE(E1,"!",A1&"|"),"@","")))
also is there an easy way to combine formulas?
Bookmarks