MrImpeccable
New Member
- Joined
- Oct 23, 2018
- Messages
- 3
So I have a range of data, some are high values that are good and some are low so I am using VLOOKUP / INDEX MATCH to score the values against a scoring system but they only work half the time.
Also It seems that Excel has trouble recognising <=30 or >=30 type operators?
I wondered if anyone could help? Many Thanks!
Also It seems that Excel has trouble recognising <=30 or >=30 type operators?
I wondered if anyone could help? Many Thanks!