I have this formula that works to give me the result I want; however, I would need the index result, if applicable rounded to the hundredths. How can I incorporate that in here?
=IF($D4="","",IF($L4="BOP",(INDEX('Phase 1'!$1:$1048576,MATCH($C4,'Phase 1'!A:A,0),11)),""))
Thanks in advance!
Rookie
Bookmarks