B
Bolwell
I have a table with three names
Exam,result,ord
Have I inserted a named range called z.
When I use the formulae =VLOOKUP("Exam",z,2) it returns the value I expect
for "exam"and the same for "result", however everytime I use the name "ord"
it returns me the value for Exam.
I have checked the range of the named area z and it includes all three in
the area. I even removed the named area and used the formulae
=VLOOKUP("Exam",B31:E33,2) again to no avail for the value "ord"
Any suggestions to what I have done wrong or possible errors to look for
would be greatly appreciated
Exam,result,ord
Have I inserted a named range called z.
When I use the formulae =VLOOKUP("Exam",z,2) it returns the value I expect
for "exam"and the same for "result", however everytime I use the name "ord"
it returns me the value for Exam.
I have checked the range of the named area z and it includes all three in
the area. I even removed the named area and used the formulae
=VLOOKUP("Exam",B31:E33,2) again to no avail for the value "ord"
Any suggestions to what I have done wrong or possible errors to look for
would be greatly appreciated