Finding Column & Row names using Cell Address

[Guest]

I am using the track changes function to identify any changes to a
spreadsheet and then requesting they list separately on a new sheet as
history. Now that I have the list of cell addresses for these changes I need
to find the column & row names of that value so that it can be loaded into a
database.

For example below cell C3 was change from 55 to 60. That change was
reflected on the history page. I need to find a way to pull the row name of
Oranges and column name of Feb.

I'm stuck. Please help.

A B C D
1 Fruit Jan Feb March
2 Apples 55 25 35
3 Oranges 40 60 33
4 Pears 30 25 20
5 Grapes 12 20 19


History spreadsheet
Who Change Range "New" "Old"
user Cell Change C3 60 55

New spreadsheet

Who Change Range "New" "Old" Fruit Month
user Cell Change C3 60 55 Oranges Feb

 

[Frank Kabel]

Hi
one way:
row name:
=OFFSET('sheet1'!$A$1,CELL("row",INDIRECT(C2))-1,0)
where C2 stores the range name (e.g. 'C3')

column name:
=OFFSET('sheet1'!$A$1,0,CELL("column",INDIRECT(C2))-1)