Excel Function for checking values in 3 columns and returning a value

Hi,

I currently have the case that my staff populates columns in excel that deviate from recommendations, that my excel gives them based on the values they enter.

I would like to facilitate my checking work by adding a function that assesses if there is a deviation between the actual data provided and the recommendation given.

it sounds easy, but it is not because the values that can be populated by my staff are strings and not really numbers.

Example attached.

Thanks for your help in advance.
Kian

I think we need more example data than the single row that you have attached - then we can look for the type of variations that can occur.

Please re-attach, with say 10 or 20 example lines of data.

Pete

Hi Pete,

I attached the updated excel which includes a mapping table. Hope that helps.

A function for the first line item would help me already as I could then replicate it.

Regards
Kian

ok, lets put it another way:
i could use the following function:
=IF(ISNUMBER(SEARCH(J3,AP3)),A1,"FALSE")

The problem is however, this function checks if the value "4" (J3) is part of the value 4+;5;5+;6;6+ (AP3). As 4 is different from 4+ this function fails to recognize it. So is there a possibility to define an excel function which checks if the exact string in cell J3 matches the content in cell AP3?

seriously, nothing?

ok, I solved it by myself.

Turns out that SEARCH and FIND functions cannot help, as they will not look for an exact string within another cell. So in my case the values 5 and 5+ would be both treated as 5. This caused headaches.

the workaround I found was the following function which combines SEARCH and LEFT. Both forced the SEARCH function to look for an exact match within another cell.
=ISNUMBER(SEARCH(left(K3,2),AX3))