Using select/lookup for pulling a product code

[gokul_krishnan]

The user select the item, unit and size. I wanna pull the price,code and factor for each combination of selection(item,unit, size).

[Aurelien]

Hi @gokul_krishnan

please have a look here:

help.appsheet.com

SELECT()

Gather column values from row in table or slice

[Gokulakrishnan_]

I tried to create an expression just for price. it is not valid. can you guys help me out??
SELECT(Prod[Price], ([Size] = [_THISROW].[Size]), ([Unit] = [_THISROW].[Unit]), ([Item] = [_THISROW].[Item]))

[Aurelien]

Hi @Gokulakrishnan_Praba

You made a good job so far.
Just missing a AND() statement

SELECT(Prod[Price],
  AND(
   [Size] = [_THISROW].[Size], 
   [Unit] = [_THISROW].[Unit], 
   [Item] = [_THISROW].[Item]
  )
)

[gokul_krishnan]

Thank you Its working, but it is not auto selecting. I entered it in valid_if

[1minManager]

Valid_IF needs to be a TRUE OR FALSE result, not a number

[gokul_krishnan]

Got it to work in initial value!! with Any()