Hi :)
I hope you can help me, I am awful when it comes to computers and I just can't seem to solve this little issue I have!
I have used the formula
=INDEX(Points!$A$5:Points!$A$43, MATCH(2, Points!$AX$5:Points!$AX$43))
to return a name from a different sheet. I will try to go into as little detail as possible to keep it simple but basically I need to use the formula in 20 cells but I may not need to fill all of them - some should stay blank as there may be no match(18 for example to match. My problem is that instead of staying blank it will return the name of the nearest result to match, for example it will return match(17. All I need to know is how to keep it blank if it doesn't match exactly!
I am so sorry if this made no sense, I really try to avoid using computer systems for the reason that I have no idea what I'm doing :P If you don't understand what I mean or need more information I will do my best to explain but it's hard when I have no idea what I'm talking about!
Thank you so much for your time!
Bookmarks