Dynamic Hyperlink using lookup
 

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?