Using select/lookup for pulling a product code

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

Hi @gokul_krishnan

please have a look here:

3 Likes

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]))

1 Like

Hi @Gokulakrishnan_Praba

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

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

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

1 Like

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

2 Likes

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

2 Likes