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

Hello Jason,

Data (Dec 14'') is the name of a worksheet. If you can't see the worksheet name then the worksheet may be hidden. Right click any worksheet tab and select Unhide and if it is possible to unhide it then the name of the worksheet should be in the dialog so select it and click OK. If Unhide is disabled (greyed out) of if you can't see the worksheet name then it is not meant for you to be able to see it so you will need to go back to the developer of the workbook.

$B$2:$I$65 is the range in the worksheet that is being referenced. The first column is tested against the value in C24 and if matches then it returns the value from the 8th column (which is column I) of the lookup range.

Without a copy of the workbook it is difficult to sure how the check marks and crosses are being applied but usually a check mark or cross is made with using Wingdings font and the colors are probably created with Conditional format that is dependent on whether it is a check or cross.

I can probably tell you more if the workbook does not contain sensitive data and you can upload a copy to OneDrive. However, I will not break passwords etc for you.

Guidelines to upload a workbook on OneDrive:

1. Zip your workbooks. Do not just save to OneDrive because the workbooks open with On-Line Excel and the limited functionality with the On-Line version causes problems.
2. To Zip a file: In Windows Explorer Right click on the selected file and select Send to -> Compressed (zipped) folder.)
3. Do not use 3rd party compression applications because I cannot unzip them. I do not clog up my computer with 3rd party apps when there are perfectly good apps supplied with windows.
4. Go to this link.  https://onedrive.live.com
5. Use the same login Id and Password that you use for this forum.
6. Select Upload in the blue bar across the top and browse to the zipped folder to be uploaded.
7. Select Open (or just double click). (Be patient and give it time to display the file after initially seeing the popup indicating it is done.)
8. Right click the file on OneDrive and select Share.
9. Do NOT fill in the form; Select "Get a Link" on the left side.
10. Click the button "Create a Link"
11. Click in the box where the link is created and it will highlight.
12. Copy the link and paste into your reply on this forum.

Hi,

Just checking in to see if the information was helpful. Please let us know if you would like further assistance.

Thanks

George Zhao
Forum Support
________________________________________
Come back and mark the replies as answers if they help and unmark them if they provide no help.
If you have any feedback on our support, please click "tnfsl@microsoft.com"