Help with SELECT Expression not showing values

[Martina_Hawkins]

I have the following Select Expression in a VC called Value

SELECT(Stock Codes[Price],[Product Code]=[_THISROW].[Product Code])
It picks up some product prices but misses a lot.

The Product below is definetley in the source data Stock Codes table, yet it is not showing. anyone have any thoughts as to why this is happening

[Rafael_ANEIC-PY]

Hello @Martina, maybe try changing the format of your product code column in your spreadsheet to “Automatic”?

[Martina_Hawkins]

@Rafael_ANEIC-PY , I’m using Excel, I have it set to General

[Martina_Hawkins]

Does anyone know of an alternative expression to the Select that I could try?
It’s very odd that it is finding some and not all of them.
Have double checked the product codes that have missing values for spaces but they are exactly the same

[Suvrutt_Gurjar]

Martina:

I’m using Excel, I have it set to General

Could you once try making the Excel cell format as “Text” in both the tables for all the populated cells for the column [Product Code] and test? Presume the column type in Appsheet is text for the column in both the tables.

[Martina_Hawkins]

That’s worked, thank you so much @Suvrutt_Gurjar