This is actually for Excel 2000.
I wish to return a value from a range of cells that each relate to a
differently named criteria, for one of those crieria.

cell1 - which will, I presume, hold the formula
cell2 - which contains criteria I am wishing to find a result for, e.g. C
range of (say) 5 cells named A to E
range of 5 cells which relate to the above sells and contain numerical
values, i.e. 1 to 5

That is, if both ranges are in logical sequence (they will not be), then the
formula should return a value of "3" when "C" is in the criteria cell (cell2)

I should be very grateful for suggestions, if it is possible.