Hi,
I'm having some trouble with the OFFSET function in a risk log I'm working on.
You'll see in the attachement that example one (which finds the reference using numbers) that the reference returned in cell E3 works fine.
However, in example two (which attempts to find the reference using letters) that the #VALUE error is returned in F17.
Anyone any ideas? Is this OFFSET function just not possible using letters? Any thoughts much appreciated.
Thanks,
Terry.
Bookmarks