I have a table, and doing a lookup for a column that’s a number. Works great on every row except one, where I am getting a lookup value that is not one number, but two numbers separated by a comma.
I cannot see any reason why the data in the Lookup Table would give me two values, anyone ever have this happen and maybe can offer a solution?
17 is the correct value from the Lookup Table, I cannot figure out where the 8 is coming from!
I included the second row with the -68 value below just to show that the Lookup is working on all other rows.
And here’s my formula for the Lookup:
Thanks for any help you can offer!