Hello,
Wondering if there’s a way to LOOKUP with only partially matched results? For example, I have a table with 2 columns: MODEL NUMBER | PRICE.
I’d like to pull the price data into another table column if the first four of that column’s text string match with the first four of MODEL NUMBER text string.
I assume the LOOKUP expression can be used, but I’m not sure if there is a simple way to accomplish it.
Thanks.
Thanks. I implemented the following formula which returns with “ORDERBY does not have a valid input”. TOP(ORDERBY(SELECT(Products[Price],[Model]=[_THISROW].[Shirt Model]), Model, FALSE), 4)
That’s alright though-- if this is not an easy method, I’ll just create another column to enter additional text values to the model if it exceeds over 4 values.
You could try to use syntax… TOP(ORDERBY(SELECT(…,4)
You can use ORDERBY only with the key column… for example with the
ref field.
Ah, got it. Thanks.
User | Count |
---|---|
41 | |
29 | |
24 | |
24 | |
13 |