Sorry about the multiple messages – I only sent it once...
I was asked how I'd discern the table number.
Strangely this information is not part of row or cell properties, so a brute-force method is required.
As far as I can tell the lookup items are found in table-order every time – so as I iterate through the lists to consolidate them, I can add the table number.
I end up with a list of lists again, but so what – it works, and I don't have to monkey with an error-handler (this time).
------------------------------------------------------------------------------
set lookupValue to "125"
set lookupFoundCellList to {}
tell application "Numbers"
tell document "Test.numbers"
tell active sheet
tell tables
set lookupFoundList to cells where its formatted value is lookupValue
end tell
end tell
end tell
# return lookupFoundList
# Adding the table number into the mix.
set tableNum to 0
repeat with ndx1 in lookupFoundList
set tableNum to tableNum + 1
repeat with ndx2 in ndx1
set end of lookupFoundCellList to {contents of ndx2, tableNum}
end repeat
end repeat
return lookupFoundCellList
end tell
------------------------------------------------------------------------------