Hello Community,
I would be grateful for any help with the following problem please:
I have two sheets as follows:
I've inserted a picture of where the result is incorrect and highlighted the row, I cannot figure out what's gone wrong...all values are formatted as Currency, I've check the data with the isnumber() and it returns a true on the look up data and main sheet...is the logic in the ifs incorrect, if so, why is only one particular row showing an incorrect result?
Any help / info would be most appreciated.
Kind regards,
KJ.
I would be grateful for any help with the following problem please:
I have two sheets as follows:
- Look Up date with values (£) to look up.
- Main sheet to bring back the values (£) and compare the values (£) against existing values (£)
I've inserted a picture of where the result is incorrect and highlighted the row, I cannot figure out what's gone wrong...all values are formatted as Currency, I've check the data with the isnumber() and it returns a true on the look up data and main sheet...is the logic in the ifs incorrect, if so, why is only one particular row showing an incorrect result?
Any help / info would be most appreciated.
Kind regards,
KJ.