Hello all, I've searched the forums before to solve my problems but this time I need to post.
I'm just getting to grips with Excel having used it for fairly simple calculations in the past but now, in a a new job, I find myself getting more in-depth.
I'm using Excel 2010 and having difficulty with vlookup and match.
Data in a table is referenced by two values in two columns, the coordinates of which should provide the answer.
But.
The values returned are offset by one, returning a different value.
I've searched the forums and found many similar problems but have been unable to relate them to my own issue (At this point I think I'm suffering spreadsheet exhaustion!).
Attached should be an image representing the issue and a copy of the workbook in xls (97-2003) and xlsx (2010) formats.
Thanks in advance.
Bookmarks