I've used a large formula to find the largest number on row 4 of another workbook and logged the number in cell P8.
I need to allocate this value and display a week number, taken from the other workbook, in row 2 (2 rows above the lookup returned value)
I'm sure it's a simple one but out of my capacity I'm afraid (learning on the job)
Many thanks!
Bookmarks