How do I auto lookup cell value from another sheet if I have the cell address?

Hello,

I use an Excel add-in, Compare.xla to run a comparison of two separate Excel worksheets. The add-in is great, in that, it shows all of the variances and lists the cell address of each variance. However, I would like to have a quick way to pull in the cell values of those cell addresses so I don't have to manually look them all up. Some of the files I'm comparing are very large and it takes me a long time to identify what all those cell addresses are. Here's an example...Compare File.jpg

So, for every cell address I have to find where the column and row intersect.....Compare File cell location.jpg

I know there has to be a way to do a lookup or something or modify that Compare.xla to pull in values instead of/or in addition to the cell address. Does anyone know how to do this?

Thank you!!

Hmm, that doesn't seem to be working. I've opened all worksheets, copied your INDIRECT functions, modified with relevant cell references, but no dice. It's giving a REF# error.

To further clarify, I have used an add-in tool to compare two separate spreadsheets. After running the comparison add-in, it creates a third spreadsheet which includes a column that returns the cell address (address from the source documents) (ie. $A$68). It also includes columns showing the variances between a given cell's values in both source documents I'm comparing. I am trying to find a way for it to actually tell me the value of $A$68 cell, which is 22053 (shown)...Attachment 342961.

Thanks. Maybe what I'm trying to achieve isn't possible. It would be nice if the Compare.xla add-in I'm using actually pulled the value of that cell to avoid looking up each one.

Hmm, that doesn't seem to be working. I've opened all worksheets, copied your INDIRECT functions, modified with relevant cell references, but no dice. It's giving a REF# error.

To further clarify, I have used an add-in tool to compare two separate spreadsheets. After running the comparison add-in, it creates a third spreadsheet which includes a column that returns the cell address (address from the source documents) (ie. $A$68). It also includes columns showing the variances between a given cell's values in both source documents I'm comparing. I am trying to find a way for it to actually tell me the value of $A$68 cell, which is 22053 (shown)...Attachment 342961.

Thanks. Maybe what I'm trying to achieve isn't possible. It would be nice if the Compare.xla add-in I'm using actually pulled the value of that cell to avoid looking up each one.

Thank you for your help. I'm just now getting back to this thread as I've been on another project. Since this is no longer a project I'm working on, how do I close the thread?