I am trying to use the match formula to find where the answer in the yellow is in the range of cells selected but it doesn't seem to be working. I have this formula before without any problems but it's not working on this occassion. I am sure it is something to do with the brackets but i can't work out how to fix it. Any help?
Thanks.
Bookmarks