I need an IF formula a column F that says If the Patient code in column A matches any of the codes in column J and if the Payer in column B is Blue Cross then give me Charge 2 in Column D, otherwise give me Charges in Column C. For Example, the first two entries do not meet the criteria so column C should be populated, by the 3rd entry that has 101 and Blue Cross should be populated as Column D charge of 215
Bookmarks