Trying to wrap my head around the indirect cell reference but not getting anywhere.
In the attached workbook I am trying to use a value in Sheet 1 Row C to reference a cell in Sheet 2 and assign that value to Sheet 1 Row D
ie Sheet 1 column C8 is "X2" the get cell value from sheet 2 Cell X2 and place that value in Sheet 1 Cell E8. Value in E8 would then read "1-Oct-2012".
I have googled and searched here but have not been able to get it right yet! LOL
Training Stats Upgrade .xlsx
Bookmarks