This is a formula I did awhile ago. The more I look at it the more I hate it. I hope to never run into something where I need to do this again... Yes it somehow works.
=IFERROR(IF(AND(VLOOKUP('Data Dump'!$K4,Conversions!$B:$G,2,0),'Data Dump'!$N4="CS"),'Data Dump'!$O4/1,IF(AND(VLOOKUP($K4,Conversions!$B:$G,4,0),'Data Dump'!$N4="PK"),'Data Dump'!$O4/VLOOKUP('Data Dump'!$K4,Conversions!$B:$G,4,0),IF(AND(VLOOKUP($K4,Conversions!$B:$G,3,0),'Data Dump'!$N4="BX"),'Data Dump'!$O4/VLOOKUP('Data Dump'!$K4,Conversions!$B:$G,3,0),IF(AND(VLOOKUP($K4,Conversions!$B:$G,5,0),'Data Dump'!$N4="BG"),'Data Dump'!$O4/VLOOKUP('Data Dump'!$K4,Conversions!$B:$G,5,0),IF(AND(VLOOKUP($K4,Conversions!$B:$G,6,0),'Data Dump'!$N4="PR"),'Data Dump'!$O4/VLOOKUP('Data Dump'!$K4,Conversions!$B:$G,6,0),""))))),"")
Bookmarks