"Plant1" is a rowlink that points to the Plant column in PlantDetails, so you can pick the plant you want. I want to use the Total column to lookup the plant name in Plant1 against Plant in PlantDetails and just return the Price at this point.
In words - in the table PlantDetails, look up the row where PlantDetails[Plant] matches the value in Orders[Plant1] and return the value in the matching [PlantDetails[Price]].
I hope this is clear and makes sense - I've tried all sorts of brackets and speech-marks - sometimes I get #N/A, but I can't get this to work.
You actually don’t need findrow. Apply this formula to the “total” column.
=[Plant 1][price]
The plant 1 column already holds all the data from the row you picked, not just the name. So once you’ve accessed that row with [plant 1] now you just pull up the data from the price column in that row.
Your findrow formula was trying to find a row Unthroupling plants table, whose first column was also a row in the plants table, which isn’t possible. So yeah, a row link only shows the first value from the row, but the entire row’s data Is in there.