Hi All I'm wrestling with using vlookups to generate conditional formatting - heres the scenario; i want the conditional format to check whether the value in the cell adjacent to the vlookup result is greater than 0 and if so the formatting is true. At the monent I have the formula in the conditional formatting as follows;
=IF((VLOOKUP(F47,$BY$5:$BZ$44,2)>0),TRUE, FALSE)
I'm sure this is not right as it produces quite erratic results; some instances of data work but others don't. For info the data in coulumn BY that are being looked up are 3 letter codes and not sorted alphabetically, the data in column BZ is an unsorted number or blank - does this have any bearing n the vlookup?
Any suggestions welcomed
Thanks
=IF((VLOOKUP(F47,$BY$5:$BZ$44,2)>0),TRUE, FALSE)
I'm sure this is not right as it produces quite erratic results; some instances of data work but others don't. For info the data in coulumn BY that are being looked up are 3 letter codes and not sorted alphabetically, the data in column BZ is an unsorted number or blank - does this have any bearing n the vlookup?
Any suggestions welcomed
Thanks