tropics123
Board Regular
- Joined
- May 11, 2016
- Messages
- 85
Hi guys, I'm running into an issue which I'm hoping someone might have a solution. For some reason, the INDEX/MATCH formula will not pull in the correct result if it's in %. For example, the IF/INDEX/MATCH formula on Sheet 1 is pulling info from Sheet 2 and the answers could be: Not Applicable, In Service, Out of Date, 100%. The issue is, the result isn't returning the correct answer when it's in %.
Example, Cell B2 on Sheet 1 is looking for Lewis' "Client Info", which is 100% and the returned result shows 1. My formula is also stating that if the answer is "100%", then show the answer as "100% Ready for Processing". However, since the result returns as "1" instead of 100%, the IF formula isn't giving the answer of "100% Ready for Processing."
Please help!
Sheet 2
Example, Cell B2 on Sheet 1 is looking for Lewis' "Client Info", which is 100% and the returned result shows 1. My formula is also stating that if the answer is "100%", then show the answer as "100% Ready for Processing". However, since the result returns as "1" instead of 100%, the IF formula isn't giving the answer of "100% Ready for Processing."
Please help!
Sheet 2
| Name | Client Info |
| Bob | Not Applicable |
| Jenny | In Service |
| Mary | Out of Date |
| Lewis | 100% |
