what cell reference is made in a cell range

[jw01]

Hi all

In my file, i have over 8K rows - see attached.

In column G, i have offical rate. I want to know what cell it is referencing. I know i can use "Control + `" and that will show me what formula is embedded in the cell.

However, for this, i want to know what cell it is referncing, so I can use it in another another. So basically, i want to copy / paste the cell refence in another workbook, using the same cell reference in column G2 down.

Is this possible? thx you in advance!

[jomaor1]

Hello!

Try putting this on your H2 cell:

Please Login or Register  to view this content.

It's the only way I could think, doesn't mean it's the only way

[GeoffW283]

I don't think the OP's version of Excel supports isformula() or formulatext().

Here is another approach. In col-H create a text value indicating which column the data in col-G is to come from. Something like in H2 copied down:

Please Login or Register  to view this content.

Then copy col-H and paste-values in the destination file. Then in the destination file create another similar if() statement to do the reverse of the above.

This approach assumes for now that the employees in the destination file match exactly with the source file(that could be addressed if any value is seen in this approach). This approach also assumes that if the value in, say, col-C is the same as col-F then the leftmost column is taken (in this case col-C).

There's also 585 exception cases where either there are errors in col-C, D or E or there is a vlookup() getting data from somewhere entirely different. These would have to be addressed one by one.