Have become so frustrated by this that I've actually signed up. Despite having searched for a solution and found varying ideas which all appear to work for those that suggested them, I haven't been able to replicate the same working formula. I've even downloaded a document with a series of lookup functions implemented but even then I'm not getting it to work for me.
I have a reference table of values. The ROWS axis features numbers incremented in 0.1 instances from 0.5 through to 2.5. The COLUMNS axis features numbers incremented in 5 instances from 5 to 40. The references between are a series of numbers associated with these values. They needn't mean anything but looking up 0.9 and 25 would give me 20 as a result. Unfortunately, when I use an Index function to look these up, I'm told there's an error in my formula.
=INDEX(Table, MATCH(X26, W2:W22,0), MATCH(X27,X1:AE1,0))
'Table' is my namespace for the entire range of my lookup table. X26 is the cell containing "0.9", as an example, and X27 is the cell containing "25", as an example. W2:W22 is the ROWS axis label, X1:AE1 is the COLUMNS axis header.
What am I doing wrong? Appreciation in advance, thanks.
Bookmarks