Look up in many table

[Willyan_Hendra]

Dear All,
Please kindly help me for the formula to get 1 data [Booking Code] from many table [Hotel] , [Tour] , [Ticket] which have their own [Booking Code] .

thank you so much

[LeventK]

How can we help with the expression without knowing your table schema, column structure etc? Please elaborate the issue and support with some scrshots so we might have a better understanding.

[Steve]

FAQ: FILTER(), LOOKUP(), MAXROW(), MINROW(), REF_ROWS(), and SELECT() Tips & Tricks 💡

How do I get a column value from the last row of this thing only? LOOKUP( MAX( SELECT( My Table[_ROWNUMBER], ([_THISROW].[Thing] = [Thing]) ) ), "My Table", "_ROWNUMBER", "Wanted Column" ) Replace My Table with the name of the table from which you want the column value; Thing with the name of the column containing a value that identifies the thing you want (e.g., Order ID); and Wanted Column with the name of the column whose value you want. See also: MAX()