Excel 2000.
Hi, Ive just no idea on how to tackle this let alone code
it. I've simplified the example but with your initial help
I can expand it to complete the whole task.
User adds data to A1:B10 a row at a time. Required
answers in c1:c10
User can enter a number from 1 to 10 in A1 then goto B1
and enter a number from 1 to 100. When the number is
enterd in B1 I would like to; use the number in A1 to goto
the correct named range and look up a value assosiated
with B1.
Example. If A1 contains 5 and B1 contains 20, when 20 is
enterd into B1 do a lookup in a range name "Five" using
the value in B1 to return a value to C1. This process to
be repeated whenever data is entered into a subsequent
rows. The numbers 1 to 10 that could be entered into
colum A represents ten named ranges.

TIA, derek..