Dynamic Hyperlink using lookup

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top