Find value
I have a spreadsheet and I need to find a value which corresponds to a row and column.
My formula - =INDEX($B$2:$L$8,MATCH(B13,$A$2:$A$8,0),MATCH($A$11,$B$1:$L$1,0))
My spread sheet.
Pts 10 11 12 13 14 15 16 17 18 19 20
7 75 80 85 90 100 105 115 130 140 150 160
6 35 40 45 50 55 60 65 70 75 85 90
5 30 30 35 40 45 45 50 50 55 55 60
4 20 25 25 25 25 25 25 25 25 25 25
3 15 15 20 20 20 20 20 20 20 20 20
2 5 10 10 15 15 15 15 15 15 15 15
1 10 10 10 10 10 10
15 <- $A$11
B13 -> 7 #N/A
Why am I getting #N/A? All values seem to be valid, no spaces or hidden characters.
Formatting?
Hi glw32,
I took your data and put it into excel and used your formula and did not get an error but 105 which is what I would expect to get.
The only thing I can think of is that the data is currently in text format rather than number?? if this is the case you can use the value function to convert from text to number
Regards
Mark