This is a bit out of my skill set, but trying to find the data used to drive this rather simple looking KPI report/worksheet with green check marks and red "X"s.  I don't see or understand where it gets the data in this lookup forumula and then how it chooses whether it needs to display a green check mark or a red X.  My main issue is I do not understand where the raw data is located, which I am guessing in "Data (Dec 14'')" wherever that may be...

Here is the forumla for the cell:

     =VLOOKUP(C24,'Data (Dec 14'')'!$B$2:$I$65,8,FALSE)

Here is what it looks like in Excel:

• Moved by Lanlan HuangMicrosoft contingent staff Wednesday, April 22, 2015 2:05 AM

Thanks OssieMac you nailed it!  Much appreciated and sorry for the delay responding!