Showing related tags and posts accross the entire site.
-
I have 2 worksheets. WkSht1 has 1 column A Client name Bob Tom WKSHT 2 has two columns Col. B has multiple client IDs per Client in Col. A A B CLIENT CLIENT ID Bob B123 B456 B789 Tom T321 T654 T987 There are variable numbers of IDs per Client I need a lookup to match on the client from WKSHT1 and retrieve...
-
=IF((AND(L16="H",H16>0)),(J16-H16+K16),IF((OR(L16="H",H16=0)),(H16+J16+K16),(IF(L16="D",(I16+DATE_TEXT(K16)),IF(L16="C",(H16+J16+K16)))))) When the user selects "d" in L16, the system needs to add a date such as 4/24/2007 in cell I16 and a number of...