halefamily104
New Member
- Joined
- Oct 11, 2016
- Messages
- 31
I hope this is a simple fix! I have an excel spreadsheet called "All Tracking" with dates as the column header. The cells in the columns show activity, for example, the column named April 29 has the text "AFF, CTC, SA" in one of the cells. I want to look in another sheet called "Billable Codes" that has the activity codes in "Codes" column and the value in "Ded" column. If the text in the column "April 29" matches any one of the cells in "Billable Code", I want it to return the value in "billable Code" ded column. Here is what I have tried:
=IF(OR(I12="HV",I12="FF",I12="AFF"),"Full","")
This works but there are a total of 60 different activity combinations (AFF, CTC, CLC or FF, HV, SA or AFF, CTC, CLC, SA etc) and I will be adding more as the project continues. Ultimately, I want to match the cell in the sheet "All Tracking" with column "April 29" to look into the" Billable code" sheet and if any of the combinations match in "Code", I want it to return the value in the "Ded" column.
I have attached two snippits of my spreadsheet.
Thanks!!
Tried to attach a pic but it doesn't work...
=IF(OR(I12="HV",I12="FF",I12="AFF"),"Full","")
This works but there are a total of 60 different activity combinations (AFF, CTC, CLC or FF, HV, SA or AFF, CTC, CLC, SA etc) and I will be adding more as the project continues. Ultimately, I want to match the cell in the sheet "All Tracking" with column "April 29" to look into the" Billable code" sheet and if any of the combinations match in "Code", I want it to return the value in the "Ded" column.
I have attached two snippits of my spreadsheet.
Thanks!!
Tried to attach a pic but it doesn't work...