I'm not really sure the type of formula I'm looking for but I'm hoping my explanation works for someone to help me. I have a review comments tab that I need to populate data from various reports. The first report is from the revenue reconciliation tab. In column A on the Rev rec. tab it lists either current or previous for period. it lists the account number in column G and the number of days in column H.
on the review comments tab I have populated the various account numbers associated with each payor type. those account numbers are in columns A:G. what I'm hoping to do is pull census days in column J based on all account numbers associated with that specific payor type. I want to pull the adjusted days in column K based on the account numbers, and then have a zero pop up if no days are associated with that account instead of #N/A. I'm hoping this is possible and I explained it well enough! Thank you for at least taking the time to read over this if not
on the review comments tab I have populated the various account numbers associated with each payor type. those account numbers are in columns A:G. what I'm hoping to do is pull census days in column J based on all account numbers associated with that specific payor type. I want to pull the adjusted days in column K based on the account numbers, and then have a zero pop up if no days are associated with that account instead of #N/A. I'm hoping this is possible and I explained it well enough! Thank you for at least taking the time to read over this if not