P
philcud
Morning all,
i have a spreadsheet with a table of date, eg
column 1 - location
column 2 - type
column 3 - condition
the colums are sorted in the above order.
on another sheet i have a report that counts condition by location and
type,
eg locations going down column a, condition across row 1, count held
in the table.
how can i create a hyperlink from the cells in this report to the
first relevant row in the data table?
i imagine it will be a lookup using match and index, but my problem is
that it is a lookup using >1 dimension.
any takers?
i have a spreadsheet with a table of date, eg
column 1 - location
column 2 - type
column 3 - condition
the colums are sorted in the above order.
on another sheet i have a report that counts condition by location and
type,
eg locations going down column a, condition across row 1, count held
in the table.
how can i create a hyperlink from the cells in this report to the
first relevant row in the data table?
i imagine it will be a lookup using match and index, but my problem is
that it is a lookup using >1 dimension.
any takers?