I have a table on Spreadsheet 'A' - O1:S1000. Is there some way to look up a
value from Spreadsheet 'B' in the table on 'A', and return either the row in
the table where the value was found, or the column where it was found, or the
cell address, or all of the above?

--
Bill @ UAMS