Does anyone know if I could use the contents of a cell and make excel read it as a name?

for example

cell a1 would be a variable cell from a lookup table ie apples or bananas

I would then like to use cell a1 to create a lookup withing a named range of either apples or banans depending on what it was at the time.

Thanks
Boo