Trying to use lookupvalue function to match Sites with the state in Power BI

[adrianvandiver]

I have one query with sites with a unknown state, and another query with sites and states known. Im trying to use lookup to find the solution, but unfortunately am getting an error of lookup value does not support comparing values of type integer with values of type text. Consider using the value or format function to convert one of the values. ABS state actual = a two letter abbreviation, Store number is a series of 5 numbers, and site ID is a series of 5 numbers. Thank you!

[adrianvandiver]

thank you, even though one of the columns was integers, it was marked as text in the format. This is whats been messing me up, thank you again!

[Greg_Deckler · Accepted solution]

@adrianvandiver Either make sure that both your Store Number and Site ID are text or numbers. One of them is currently text and the other is a number. Or, you can always try adding & "" to the number column or + 0 to the text column in your formula.