Hi all,
having real trouble with a lookup not returning a value. I have checked the format of related columns and all are set to number.
I believe the lookup ref is the problem as this is originating from a formula (A3&V3) to combine 2 other numbers to give the row a unique reference. This is in column Y.
If I copy and paste the results in as values then I get the option within the cell to convert the text to a number. As soon as I do this the lookup works perfectly!
does anybody have any idea how I can set this column so that this data is stored as a number with the formula still being used?
having real trouble with a lookup not returning a value. I have checked the format of related columns and all are set to number.
I believe the lookup ref is the problem as this is originating from a formula (A3&V3) to combine 2 other numbers to give the row a unique reference. This is in column Y.
If I copy and paste the results in as values then I get the option within the cell to convert the text to a number. As soon as I do this the lookup works perfectly!
does anybody have any idea how I can set this column so that this data is stored as a number with the formula still being used?