Take a look at VLOOKUP in help, it should do what you want.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"BHUVANESWARI.P" wrote in message
...
I have cell with data validation with 25 entries in the list in one sheet.
I
want to have equivalent values in another cell of another hyper-linked
sheet.
For eg: If I click a value of say '1000', I should get '2000' as value in
a
cell of hyper-linked sheet. Like this, if I click any one of 25 values, I
should have respective (corresponding) equivalent value. My problem is I
can
try with 'IF' function for only 7 times and 'Lookup' function for 13
times.
Now kindly me what to do?-EXCEL-2003.