VLOOKUP and INDEX MATCH not working all the time / Intermittant results

[MrImpeccable]

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!

 

[steve the fish]

Cant really help without at least a clue on the set up of the sheet and what you are attempting to do.

 

[MrImpeccable]

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!

I would love to post an attachement but it is not allowing me to do so?

 

[Fluff]

Cross posted https://www.excelforum.com/excel-fo...he-time-intermittant-results.html#post4996920

While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules).
This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

 

[MrImpeccable]

Okay thanks, yes it is on the other post. Thanks for any help.