Hi All,

I am trying to find a way to link a cell between two worksheets.
Unfortunately copying and pasting the link doesnt work because the data in
the worksheet I am referencing may change rows. For example...

If I have a string in cells A1 and B1 and a numerical Value in C1 and then
when I next run the report, records might be added that would move these to
say A12, B12 and C12 respectively.

on another worksheet, I have a static report that needs to reference these
same values even though they may have moved rows.

Basically I need the formula to say that if string in column A equals one
thing and the string in column B equals on thing, then put the value from
column C in the cell.

Hope this makes sense and any appreciate any help I can get.