Similar to the function formula Vlookup

[stvn_003]

The tenth column of the second table is the last No. SO, what I want is that in the last column the price of the last sales order that is marked in the first table also appears.

Says 17.91, should read 16.66

[danieloberbilli]

It can't be done by looking up a cell in another (straight/pivot) table object, but can be done by set analysis. What we need to know/understand are the logical tables in the background (data fields and tables involved) and the dimensions / expressions of your table objects.

[stvn_003]

I am attaching the file

[Siva_Sankar]

Hi Steven,

use this expression.
find the attachment =Alt(min({$}ocd_iprnetsap),0)

[stvn_003]

Thanks Siva, but that only works for this specific case, but there may be cases where it is higher, lower or middle

[stvn_003]

any idea for this, please

[ramoncova06]

you can use this

only({< occ_nocedi = {"$(=MaxString({$<ocd_precio_ok = {N} >} (occ_nocedi)))"} >} ocd_iprnetsap)